2 Replies Latest reply: Aug 18, 2016 3:22 AM by Michael H. RSS

    Qlik Sense combine in variables stored set expressions

    Michael H.

      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