Sorting in Qliksense

[#1]

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

'

[dwforest · Accepted solution]

sort by expression

match([Sub Area], 'LATE TO LAUNCH' ,M-Plan','TO BE LAUNCHED','WIP')

Note that case matters you show both so just make sure it matches what you really have.