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: 
ziabobaz
Creator III
Creator III

Set Analysis, I want current selection to affect the data

Hi,

I have the following expression:

sum( {$<Season=('*winter')>} SALES )


..and it shows me the Sales disregarding current selection in the filter 'Season'. I want to show Sales for all seasons containing "winter" when no selections are made in the filter 'Season', but I don't want to show sales, when the season selected by the user does not contain "winter" in it's name.


Isn't the '$' sign supposed to solve the problem?



1 Solution

Accepted Solutions
sunny_talwar

Try this:

Sum({$<Season *= {'*winter'}>} SALES)

Implicit Set Operators

View solution in original post

2 Replies
sunny_talwar

Try this:

Sum({$<Season *= {'*winter'}>} SALES)

Implicit Set Operators

ronnyhu
Contributor
Contributor

This solution hardcoded "winter".

What if I want to use selected Season, it might be Spring, Summer, Autumn, Winter? What is the correct expression? eg Sum({$<Season *= {'*SelectedSeason???'}>} SALES) ?

Please help