1 Reply Latest reply: Mar 22, 2018 6:35 PM by David Forest RSS

    Sorting in Qliksense

    Balaji Rajendran

      Hi

       

      I have a pivot table with a Row with a field called 'Sub Area' and have a nested if  in the column  with the expression '

      if(Stops='Stops','Stops',

      IF(Print=''

         ,'Mplan'

         ,if(Print=1

            ,'WIP'

           

            ,if(SchStart<MonthEnd(today())

              ,'Late to launch'

              ,'To be launched'

             )

          )

      )

      ) '

       

      So the labels along the column heading will be WIP,STOP , LATE TO LAUNCH AND TO BE LAUNCHED.

      Is there a way to sort this column heading in a specific order, say Late to launch, M-Plan, To be launched, WIP, Stop ?

       

      Many Thanks

      CR

       

       

      '