Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Not applicable

Re: sorting

May be using Match function

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

Not applicable

Re: sorting

This is what I got

by adding this 

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

sunny_talwar
Not applicable

Re: sorting

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
Not applicable

Re: sorting

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.