Sort dimension Month using my predefined order

[#1]

Hi,

How can I sort my dimension Month (X Axe) in my predefined order (Jan, Feb, Mar, Apr, May, Jun, Jul etc...)

Many Thanks.

Jerome.

[sushil353]

Hi

check out this : Sorting in qlikview

HTH

Sushil

[ajaykumar1 · Accepted solution]

Hi,

Table :

Month,

---

---

from qvd1;

Load * inline [

Month,Order

Jan,1

Feb,2

--

--

Dec,12

];

Then go to the Sort option and select the month dimension and in the expression you can put the field name as ORDER and play with ascending/desneding.

Regards,

Ajay

[#4]

Properties-->Sort--> Numeric Value--> Ascending

[PrashantSangle]

Hi,

Go to Sort tab->Expression->write Expression like

wildmatch(month,'jan','feb','mar','apr','may','jun','jul','aug','sep','oct','nov','dec')

Regards

[#6]

Thanks!