3 Replies Latest reply: Mar 24, 2017 11:24 AM by omar bensalem RSS

    switching between measures

    Nicholas Truss

      Is there a quicker/more user friendly way to change to alternative measures in Qlik Sense rather than going through the exploration menu?

       

      Thanks,

       

      Nick

        • Re: switching between measures
          omar bensalem

          Suppose I have 3 measures:

          sum(CA)

          sum(Quantity)

          sum(Marge)

           

          And I want to have all 3 measures in the same graphic.

           

          You can add them as alternative measures as you're doing.

           

          ANother way is to create an inline table in the script:

           

          Let's call it:

          Measures:

          load * inline [

          Measure

          CA

          QUANTITY

          MARGE

          ];

           

           

          Now, in our graphic we only have to use one measure:

          sum(if(Measure='CA',

          CA,

          if(Measure='QUANTITY',

          [Quantité] ,

          if(Measure='MARGE',

          Marge ))))

           

          Add the new created field Measure as a filter object, and when you select a value, your measure will change with your selection:

           

          Example:

          I select CA: I get sum(CA) as a measure in my bar chart

          Capture.PNG

           

          I select Marge:(I get sum(marge) as a measure of my bar chart

          Capture.PNG

           

          Hope this helps