2 Replies Latest reply: May 15, 2018 6:09 AM by santhosh kasam RSS

    Sequence of dimensions in Qlik Sense

    santhosh kasam

      Hi All,

       

      I want to know if there is any way to identify the order of the dimensions of a pivot table in qlik sense.

      For Example: I have below dimensions Supervisor, Handler, Month in the same sequence while creating the pivot.

      Now i want to know the sequence of these dimensions after the user changes the order in UI.

       

      Thanks in advance

       

      Regards

      Santhosh Kasam

        • Re: Sequence of dimensions in Qlik Sense
          Petter Skjolden

          If you want to know that in one or more of the measures in your Pivot Table you can use the GetObjectField(<index>) function to retrieve the name of the dimension. <index> is the position. The index starts at 0 for the first occuring dimension and continues with 1 as the second dimension and so forth...

           

          It reflects the current order of dimensions at all times. So I believe this is exactly what you are looking for.

           

          You could do something like this:

           

              If( GetObjectField(0) & '|' & GetObjectField(1) = 'Sales Person|Region' , .......

           

           

          I KNOW - it is a horrible name for the function - of course it should have been named DimensionName(). Nobody could ever guess by looking at the name GetObjectField that it would give you the dimension name right?