Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
adwitiya
Contributor

Using GetFieldSelections in set analysis

Hi All,

I have a dashboard with [Month] as a filter. Only one value for [Month] can be selected at a time.

I'm using the code:

sum({<TransitionMonth=${"=GetFieldSelections(Month)"} , Version={'ABC'}>}Value)

and with 'Aug' filtered for [Month], I'm getting the 4th column in the below table:

set analysis.PNG

What I need is for each row to give me the value of 2.2, since that is value for [TransitionMonth]=[Month]=Aug.

What am I doing wrong?

1 Solution

Accepted Solutions
adwitiya
Contributor

Re: Using GetFieldSelections in set analysis

This worked!

sum(total{<TransitionMonth={'$(=getfieldselections(Month))'} , Version={'1YP'}>}Inflows)*change/100


It was missing a TOTAL function

18 Replies
YoussefBelloum
Esteemed Contributor

Re: Using GetFieldSelections in set analysis

Hi,

try this:

sum({<TransitionMonth={'$(=getfieldselections(Month))'}>} , Version={'ABC'}>}Value)


adwitiya
Contributor

Re: Using GetFieldSelections in set analysis

It displays null.

OmarBenSalem
Esteemed Contributor

Re: Using GetFieldSelections in set analysis

Try :

sum({<TransitionMonth={"$(=concat(Month,'","'))"}>} , Version={'ABC'}>}Value)


YoussefBelloum
Esteemed Contributor

Re: Using GetFieldSelections in set analysis

My bad, it was a mistake, try this:


sum({<TransitionMonth={'$(=getfieldselections(Month))'} , Version={'ABC'}>}Value)

OmarBenSalem
Esteemed Contributor

Re: Using GetFieldSelections in set analysis

Didn't pay attention to the "one month selection part" ;

But even in this case, with concat it should work for one or different Months selection while I'm not that sure It would work with GetFieldSelections(Month) if more than one month is selected..

adwitiya
Contributor

Re: Using GetFieldSelections in set analysis

Youssef, This gives '2.2' for Aug, but zero for all other months.

YoussefBelloum
Esteemed Contributor

Re: Using GetFieldSelections in set analysis

Yes that's why I removed my comment, because when I use CONCAT it's often when I select multiple values.

#مريجل صاحبي

YoussefBelloum
Esteemed Contributor

Re: Using GetFieldSelections in set analysis

check suppress when null in "complement"

adwitiya
Contributor

Re: Using GetFieldSelections in set analysis

Is there a way to do it without using GetFieldSelections?