topic Re: Qliksense if GetFieldSelections in dimension in Visualization and Usability

Qliksense if GetFieldSelections in dimension

zhaohaifeng — Wed, 09 Oct 2019 08:07:10 GMT

Hi All,

In our requirement, we want to add one filter Flag(no relationship) with Region and Territory, in our chart dimension, we want to use based on what we select in filter, the dimension is =if(GetFieldSelections(Flag)='Territory',rep,[区]), screenshot as below,

but when we click the bar in the chart , it should dimension Region selected in the top, now Territory also in the top selection, do you know how can i do, dont let another dimension selected? Also attached the qvf for youre refrence.

Best Regards,

Haifeng

Re: Qliksense if GetFieldSelections in dimension

Lisa_P — Wed, 09 Oct 2019 22:13:12 GMT

Not sure if this is what you are asking, but if you go to the Flag field from the Assets panel on the left in Edit mode, you can right click on the Flag field and go into Field settings where you can check the box to make sure that either Region or Territory is always selected, but not both. (Always one selected value)

Re: Qliksense if GetFieldSelections in dimension

CELAMBARASAN — Thu, 10 Oct 2019 01:00:55 GMT

Create a Variable lets vDimension with below expression

=if(Flag='Territory','rep','[区]')

use $(vDimension) as your dimension

Re: Qliksense if GetFieldSelections in dimension

zhaohaifeng — Fri, 11 Oct 2019 00:43:21 GMT

Thanks. it works now.

Can you help to explain the reason why with variable no issue happend? Thanks for your time first.

Best Regards,

Haifeng

Re: Qliksense if GetFieldSelections in dimension

CELAMBARASAN — Mon, 14 Oct 2019 03:52:34 GMT

Qlik does the selection whatever you given as expression in the dimension

=if(Flag='Territory',rep,[区])

but when you use the vDimension variable in place of above expression, which has value of =if(Flag='Territory','rep','[区]'). it will evaluate and use the output value as dimension, it does the selection for that field only.

Note: when I use the variable, field names are within single quotes.

PS: Mark this post as solution, to avoid others spending time on your post to answer it.