Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

salto
Valued Contributor 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!

Tags (1)
1 Solution

Accepted Solutions
marcus_malinow
Valued Contributor III

Re: GetFieldSelections... starting with NOT

Use the maxvalues parameter.

For example GetfieldSelections(month, , 12)

2 Replies
marcus_malinow
Valued Contributor III

Re: GetFieldSelections... starting with NOT

Use the maxvalues parameter.

For example GetfieldSelections(month, , 12)

salto
Valued Contributor II

Re: GetFieldSelections... starting with NOT

Thank you! I didn't know this option.

Cheers!

Community Browser