Sorting in Qliksense

Thu, 22 Mar 2018 09:52:09 GMT

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

Re: Sorting in Qliksense

dwforest — Thu, 22 Mar 2018 22:35:36 GMT

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.