topic Re: order by year in QlikView

order by year

Wed, 25 Jun 2014 07:59:38 GMT

Hi, currently I have this:

How can I make it such that it is ordered by year? meaning 2013 on top. Thanks.

selvakumarsr — Wed, 25 Jun 2014 08:02:21 GMT

In Sort tab..In Expression (=Year) and select Ascending

MK_QSL — Wed, 25 Jun 2014 08:02:48 GMT

Go to Sort tab

Expression

DUAL(Date#(SummaryMonth,'M/YYYY'),Date(Date#(SummaryMonth,'M/YYYY'),'YYYYMM'))

alexandros17 — Wed, 25 Jun 2014 08:03:00 GMT

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

sujeetsingh — Wed, 25 Jun 2014 08:03:29 GMT

The correct way use expression sorting