topic Re: Sorting Issue in QlikView

Sorting Issue

panipat1990 — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Sorting Issue

sunny_talwar — Mon, 12 Sep 2016 08:48:54 GMT

May be use a sort expression:

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

Re: Sorting Issue

robert_mika — Mon, 12 Sep 2016 08:54:16 GMT

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;