Sorting time in Filter Pane

[zelalemdatew]

Hi all,

So, I am fairly new to Qlik. I created an app with time filter pane and time is AM and PM format. I tried to sort using the sort tab, but it is sorting like 1AM 1PM 2AM 2PM... I would like to see the time to be 1AM 2AM 3AM... 11AM and then PMs will continue. Can anyone please help ?

Thanks in advance.

[StarinieriG · Accepted solution]

Hi,

try to sort by this expression

Purgechar(field,'AMPM')+If(Index(field,'AM')>0,0,12)

[Vegar]

You could try to create a time of your field in the script. 

Time#(YourTimeField, 'hTT') as YourTimeField

Then you can sort numerically. 

[zelalemdatew]

It works. Thank you so much!

[Vegar]

That's great!

[zelalemdatew]

This worked Thanks!