Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
dmk223
Contributor II
Contributor II

GetfieldSelection with alternate states

Hello, 

I have table with diffrent alternative states. Within this table there are sales data (Revenue, quantity etc.).  Each alternative state have its own date filter ( MonthYear). 

In each measure name i would like to have measure name and selected values from MonthYear filter. 

I've tried with :

='Revenue  ' & GetFieldSelections([MonthYear], 'state1')

But this works only when table alternative state is set to state1 which i cannot set as there are fields with diffrents alternative states in the table.

Labels (2)
1 Reply
dmk223
Contributor II
Contributor II
Author

As for now im using this :

='Revenue  '&GetCurrentSelections(chr(13), '=', ',' ,5,'state1')

 

It works fine but i only need MonthYear in a label, instead this gets me all of the user selections.