4 Replies Latest reply: Feb 13, 2018 7:23 AM by sandip Ghosh RSS

    Alternate dimension in Qlik Sense -- need help

    sandip Ghosh

      Hi,

       

      The dynamic dimension name in chart Title is  possible if you are using Alternate dimension in Qlik Sense?

       

      Thanks,

      Sandip Ghosh

        • Re: Alternate dimension in Qlik Sense -- need help
          omar bensalem

          Nope; that's not possible;

          But u want to show it in the title; I would suggest u not to use alternative dimension but rather do as follow:

           

          - go to script, and create an inline table :

          load * inline [

          DimensionID, Dimension

          1, Dim1

          2, Dim2

          ];


          - Now in ur sheet, above ur chart, add this new Dimension field as a filter

          - In ur chart, instead of using alternative dimensions; use a calculated dimension as follow:

          if(DimensionID=1, YourFirstDimension, YourSecondDimension)

           

          -Now, in the title , u add this information to know which dimension we're working with

          ='My measure by '&Dimension


          ps: u can add in the adds-on, to force users to select only one dimension: Count(Distinct Dimension)=1


          Or, as a filter, use an extension and not the native Sense filter object, to force the user to be able to select only one Dimension:

          example:

          http://branch.qlik.com/#!/project/5702b378bf1c421463412c90