Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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

1 Solution

Accepted Solutions

Re: Qlik Sense combine in variables stored set expressions

May be try this:

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

With following variables

a -> Country={'Sweden'}

b -> Year={'2009'}

Capture.PNG

2 Replies

Re: Qlik Sense combine in variables stored set expressions

May be try this:

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

With following variables

a -> Country={'Sweden'}

b -> Year={'2009'}

Capture.PNG

Not applicable

Re: Qlik Sense combine in variables stored set expressions

Sunny my hero, thanks a lot!