topic Qlik Sense combine in variables stored set expressions in App Development

Qlik Sense combine in variables stored set expressions

Sat, 16 Nov 2024 10:27:05 GMT

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

sunny_talwar — Thu, 18 Aug 2016 01:02:57 GMT

May be try this:

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

With following variables

a -> Country={'Sweden'}

b -> Year={'2009'}

Thu, 18 Aug 2016 07:22:06 GMT

Sunny my hero, thanks a lot!