Discussion Board for collaboration on QlikView Scripting.
Hi, currently I have this:
How can I make it such that it is ordered by year? meaning 2013 on top. Thanks.
Go to Solution.
Go to Sort tab
In Sort tab..In Expression (=Year) and select Ascending
In the sort tab check only expression and write:
=Right(myField, 4) & Num(Mid(1,index(myField, '/')-1),'00')
where myField is the field you have used
let me know
The correct way use expression sorting