Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
ziabobaz
Contributor II

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?



Tags (1)
1 Solution

Accepted Solutions

Re: Set Analysis, I want current selection to affect the data

Try this:

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

Implicit Set Operators

1 Reply

Re: Set Analysis, I want current selection to affect the data

Try this:

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

Implicit Set Operators

Community Browser