Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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

- Marcus

View solution in original post

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

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

- Marcus

View solution in original post