1 Reply Latest reply: Sep 21, 2017 9:50 AM by Hans Christian Riis RSS

    Combine selection from two filters into a new chart dimension?

    Hans Christian Riis

      Hi all,

       

      I'm trying to explore the possibilities in Qlik sense with the use of as many standard components and functions as possible. Currently I try to make a comparison sheet. In my load script I generate my two identical dimensions by:

       

      Comparison_1:

      Load comparison as comparison1

      Resident Source;

       

      Comparison_2:

      Load comparison as comparison2

      Resident Source;

       

      This allows me to set up to filters controlling each their charts, which is all good.

       

      Now I'm wondering if it's possible to combine the selections from comparison1 and comparison2 into a new dynamic dimension for my graph. The result should be to select Aabenraa from the comparison1 and Frederiksberg from comparison2, getting the shown chart.

       

      2017-09-21_10h43_19.png

       

      I tried looking into these functions:

      Aggr()

      GetFieldSelections()

      Pick()

      Match()

      ValueList()

       

      But I can't figure out how, or if, its possible to obtain this. Hope someone can point me in the right direction