Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

order by year

Hi, currently I have this:

Untitled4.png

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

1 Solution

Accepted Solutions

Re: order by year

Go to Sort tab

Expression

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

4 Replies
selvakumarsr
Contributor

Re: order by year

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

Re: order by year

Go to Sort tab

Expression

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

Re: order by year

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
Honored Contributor III

Re: order by year

The correct way use expression sorting

Community Browser