Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to sort this hours in ascending order!

Hi ,

I got this strange bit of sorting the hours in ascending order.

I have used the sort option increase ascending order by hours . But still cant win.

Any one can help pls.

This is the screen shot

9 Replies
PrashantSangle

hi,

try sorting with expression,

use below expression -> pick(match("0-1Hrs","10-11 Hours",....))

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Chanty4u
MVP
MVP

it is excel? if yes go for custom sort

if it is in qlik  try below

=match(DimensionField,'value1','value2','value3')

Anonymous
Not applicable
Author

Hi,

It is working fine at Qlik by sorting at the table level.

But i am wondering how do you write that expression at nprinting.

Anonymous
Not applicable
Author

yes it is in excel. as i am doing the reporting in nprinting.

Can you elaborate on custom sort?

PrashantSangle

check sureshqv‌ answer..

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Chanty4u
MVP
MVP

select the column and select the sort &filter   icon in excel home page

and in that you will find the custom sort write your order and use the same.custom.PNG

PrashantSangle

check below url for better understanding

https://www.extendoffice.com/documents/excel/897-excel-sort-columns.html

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable
Author

Strange,I cant able to see that sort by option.

Chanty4u
MVP
MVP

select single cell then only you can able to see