Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Sorting Issue

May be use a sort expression:

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


Capture.PNG

2 Replies

Re: Sorting Issue

May be use a sort expression:

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


Capture.PNG

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;

Community Browser