If you would like to know more about set analysis? Have a look at Outer Sets or Literal vs Search Strings. This is proven by the fact that the minus and equal sign are not needed to be written together ‘-=’ is a single operator, where ‘=-‘ are in fact two, the equal sign telling Qlik to make selections and the – sign to select everything except Belgium. This means that however we make selections, we will always see all sales, expect for Belgium. Belgium is excluded.īut what happens with ‘=-‘? In that case we tell Qlik to make selections in the Country field, for everything except Belgium. However in the ‘-=’ set analysis we will only see the 80 of Denmark. We see that the total result should be 180. Referring to the example above we see that Belgium and Denmark are both selection. Therefor it is still possible to make selections, however, Belgium will never show up in the result of the expression. By effect, this will show all possible selections in the country field, except Belgium. This will make Qlik exclude Belgium from your selections. Now let’s place a minus in front of that to make the expression Sum(} Sales). Whatever other selection you will make, it will still only show the Sales for that condition. For example the expression Sum(} Sales) will select only Belgium in the country field. We should view the ‘=’ sign as an operator which selects or actually replaces current selections. The difference lies in the placement of the ‘-‘ minus sign. Keeping that in mind and lets evaluate what both statements do. As in the question, we tell Qlik to make a selection in the Country field. Based on the values in the set condition, Qlik evaluates this as a selection on chart level. As we all know, set analysis works by sort of making selections within the aggregation itself. The trick in this question is the fact that the end user still wants to make selections. It will underline the statement in red, but the top of the Edit Expression bar will still read. And that is certainly not to our surprise since set analysis is the staple (and maybe the bane) of most Qlik developers. Does work for not equal to despite showing a syntax error. Example: If the user selects Margin, Sales, and Customer in the. I want to display the selections but only of a certain source, like KPISource 'SAP'. The user can select several KPI's with fieldname KPIDescription. Quite an impressive amount of answers this time around. I'm looking to use GetFieldSelections with a set analysis to only get certain values the user has filtered, not all of them. Last Friday we asked the following Qlik Data Architect certification practice question about excluding values in Set Analysis: Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |