Discussion Board for collaboration on QlikView Scripting.
I have an issue with the application as there is a cross table expression from that date field(Not a proper date field, just for time representation) is taken.
the format of date field is like this
On this filed, i need to sort a chart in ascending order of time. But i cant as it is not showing proper date stmap.
Please help finding any solution.
Thanks in advance.
Text Order will handle proper sorting
I tried Text Order Sorting. But its also not giving correct order.
Would you mind sharing your app? Preparing examples for Upload - Reduction and Data Scrambling
if(isnum(field), date(MakeDate(Left(field,4), num(Right(field,2)))),
)))) as field
Thanks for the explanation massimo.
I have tried 'Match' in the expression for sorting and got the right order for all the values as required.
=Match (expr, vlaue1, value2,......value10)
Value1 will be given index# 1, value2 will be given index# 2 and so on.
So, by keeping this expression in ascending order had worked for me.