Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
schumi1980
Contributor III
Contributor III

Show values for months not selected

Hi All

How do I write an expression in a pivot table that shows the values that are not selected by a list box/current selection for a certain dimension:

For example:

I choose months 1-3, I need the expression to show months 4-12.

Is that possible?

Many thanks.

Best regards,

Jan

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

You could use something like this: sum({< Month = e(Month) >} VALUE)

- Marcus

View solution in original post

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

You could use something like this: sum({< Month = e(Month) >} VALUE)

- Marcus