Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sorting

Is there a way in a pivot table to sort my delivery ID's in order?

Like This below

3AM

8AM

1PM

3PM

4 Replies
sunny_talwar

May be using Match function

Match(DelivID, '3AM', '8AM', '1PM', '3PM', .....)

Not applicable
Author

This is what I got

by adding this 

match(DelivID,'3AM','8AM','1PM','3PM','5PM-WK','8PM','11PM','OUTS','STAT',' ')

sunny_talwar

I think you did it as a calculated dimension, why don't you try this now

Dual(DelivID, Match(DelivID,'3AM','8AM','1PM','3PM','5PM-WK','8PM','11PM','OUTS','STAT',' '))

rupamjyotidas
Specialist
Specialist

Script : you can add

Dual(DelivID, Match(DelivID,'3AM','8AM','1PM','3PM','5PM-WK','8PM','11PM','OUTS','STAT',' ')) as DelivID


In this was you don't need to add calculated dimension in all the charts in which you use this field.