Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: 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!