Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Sorting in Qliksense

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

'

1 Solution

Accepted Solutions
dwforest
Valued Contributor

Re: Sorting in Qliksense

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.

1 Reply
dwforest
Valued Contributor

Re: Sorting in Qliksense

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.

Community Browser