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: 
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!