Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
try to sort by this expression
Purgechar(field,'AMPM')+If(Index(field,'AM')>0,0,12)
Hi,
try to sort by this expression
Purgechar(field,'AMPM')+If(Index(field,'AM')>0,0,12)
You could try to create a time of your field in the script.
Time#(YourTimeField, 'hTT') as YourTimeField
Then you can sort numerically.
It works. Thank you so much!
That's great!
This worked Thanks!