Sorting Issue

[panipat1990]

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

[sunny_talwar · Accepted solution]

May be use a sort expression:

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

[robert_mika]

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;