Discussion Board for collaboration on Qlik NPrinting.
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
try sorting with expression,
use below expression -> pick(match("0-1Hrs","10-11 Hours",....))
it is excel? if yes go for custom sort
if it is in qlik try below
It is working fine at Qlik by sorting at the table level.
But i am wondering how do you write that expression at nprinting.
yes it is in excel. as i am doing the reporting in nprinting.
Can you elaborate on custom sort?
check sureshqv answer..
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.
check below url for better understanding
Strange,I cant able to see that sort by option.
select single cell then only you can able to see