Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

panipat1990
Contributor II

Sorting Issue

Hi Team,

I have a reqruirment. How to sort Composite Key.. For this i am Sharing a qvw. in this A bar garph..i want to sort year month Key.Please Help me For sorting Issue

1 Solution

Accepted Solutions
MVP
MVP

Re: Sorting Issue

May be use a sort expression:

=Date#(Key, 'YYYY-MMM')


Capture.PNG

2 Replies
MVP
MVP

Re: Sorting Issue

May be use a sort expression:

=Date#(Key, 'YYYY-MMM')


Capture.PNG

Highlighted

Re: Sorting Issue

or you can change your script:

RegionSales:

Load * Inline

[ Region, Year, Month, Sales

North, 2014, 5, 245

North, 2014, 5, 347

North, 2014, 6, 127

South, 2014, 6, 645

South, 2013, 5,    367

South, 2013, 5, 221

East,   2012,   7,    203

West,   2011,   8,    289

];

Tab:

Load*,

   Dual(Year&'-'&month(makedate(2001,Month,1)),Year&Month) As Key

Resident RegionSales;

Drop Table RegionSales;