Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

jvk_sharma
Contributor III

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

Re: How to sort this hours in ascending order!

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.
Chanty4u
Esteemed Contributor III

Re: How to sort this hours in ascending order!

it is excel? if yes go for custom sort

if it is in qlik  try below

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

jvk_sharma
Contributor III

Re: How to sort this hours in ascending order!

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.

jvk_sharma
Contributor III

Re: How to sort this hours in ascending order!

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

Can you elaborate on custom sort?

Re: How to sort this hours in ascending order!

check sureshqv‌ answer..

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Chanty4u
Esteemed Contributor III

Re: How to sort this hours in ascending order!

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

Re: How to sort this hours in ascending order!

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.
jvk_sharma
Contributor III

Re: How to sort this hours in ascending order!

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

Chanty4u
Esteemed Contributor III

Re: How to sort this hours in ascending order!

select single cell then only you can able to see

Community Browser