Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense combine in variables stored set expressions

Hi everyone

Got 2 variables, let's call them a and b in which I stored some set expressions, i.e. {<country={'Sweden'}>} and {<year={'2009'}>}

If I use only one of them at a time, i.e. sum($(a)Sales), there's no issue.

What I want is to use both of them at the same time: I want

sum({<Country={'Sweden'}, year={'2009'}>}Sales)

but I Need the set expressions to be done by variables and I Need to be able to Combine different set Expression variables like

sum($(a)$(b)Sales)

Has anyone an idea how to solve that?

Thanks in advance and

best regards

Michael

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

May be try this:

Sum({<$(a),$(b)>}Sales)

With following variables

a -> Country={'Sweden'}

b -> Year={'2009'}

Capture.PNG

View solution in original post

2 Replies
sunny_talwar

May be try this:

Sum({<$(a),$(b)>}Sales)

With following variables

a -> Country={'Sweden'}

b -> Year={'2009'}

Capture.PNG

Not applicable
Author

Sunny my hero, thanks a lot!