Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
salto
Specialist II
Specialist II

GetFieldSelections... starting with NOT

Hello,

In a previous post Two expressions - for the second, show only totals, I have managed to show only the totals for a second dimension (well, treating it as an expression).

Now I need to finish that chart, and I am using GetFieldSelections to show / hide different columns.

And I am using GetFieldSelections to take into account some columns' values to calculate the totals.

The main problem is the value  of GetFieldSelections, when it comes to Months:  If select from January to September, the GetFieldSelections(Month) function will return a value that  starts with NOT (NOT oct, nov, dic)

Is it possible to "force" this function, or any other, to retrieve the values of the selected Months?

Thanks in advance!

1 Solution

Accepted Solutions
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Use the maxvalues parameter.

For example GetfieldSelections(month, , 12)

View solution in original post

2 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Use the maxvalues parameter.

For example GetfieldSelections(month, , 12)

salto
Specialist II
Specialist II
Author

Thank you! I didn't know this option.

Cheers!