topic Re: Sort dimension Month using my predefined order in QlikView

Sort dimension Month using my predefined order

Mon, 08 Sep 2014 06:45:20 GMT

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.

Re: Sort dimension Month using my predefined order

sushil353 — Mon, 08 Sep 2014 06:49:53 GMT

check out this : Sorting in qlikview

HTH

Sushil

Re: Sort dimension Month using my predefined order

ajaykumar1 — Mon, 08 Sep 2014 06:52:02 GMT

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

Re: Sort dimension Month using my predefined order

Mon, 08 Sep 2014 06:54:27 GMT

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

Re: Sort dimension Month using my predefined order

PrashantSangle — Mon, 08 Sep 2014 06:56:03 GMT

Hi,

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

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

Regards

Re: Sort dimension Month using my predefined order

Mon, 08 Sep 2014 07:19:50 GMT

Thanks!