topic Re: Sorting calculated dimension in QlikView

Sorting calculated dimension

prasadreddy — Tue, 08 Oct 2013 14:47:13 GMT

Hi All,

Below is my calculated dimension, so, i want to sort the bar chart by 'Month_Name' wise,

Month contains the data like: 201301, 201302, 201303, 201304

Month_Name: Jan, Feb, Mar, Apr

Please update me ASAP,

Thanks in advance

IF($(v_OVar1) = 0,

Month_Name& '-' &

Left(

[Month],4),

IF(

FY_Quarter='Q1',

Qtr_Month,

IF(

FY_Quarter='Q2',

Qtr_Month,

IF(

FY_Quarter='Q3',

Qtr_Month,

IF(

FY_Quarter='Q4',

Qtr_Month
))))
)

Re: Sorting calculated dimension

bbi_mba_76 — Tue, 08 Oct 2013 14:53:11 GMT

Hi,

you could use the dual function or load the data in the correct order, so you could sort by load order

Re: Sorting calculated dimension

israrkhan — Tue, 08 Oct 2013 15:00:04 GMT

as Barini said above, one more idea is you can load inline like,

LOAD * INLINE[

NO, MONTH

1, Jan

2, feb,

3, mar

...

....

....and so

];

THEN USE EXPRESSION IN YOUR SORT ORDER, ON NO...

Re: Sorting calculated dimension

Anonymous — Tue, 08 Oct 2013 16:11:33 GMT

Israr

Or simply sort using expression :

num(mid( [Month] ,5,2))

or you could use this expression if you prefer:

num(month(date#( [Month_Name] ,'MMM')))

Best Regards, Bill

Re: Sorting calculated dimension

prasadreddy — Wed, 09 Oct 2013 07:29:03 GMT

Hi Bill,

In my bar chart, it should show months on X-axes, but it showing order like,

Feb, Mar, Jan, Dec, Nov,

But i want to show like:

Nov, Dec, Jan, Feb, Mar,

Re: Sorting calculated dimension

saumyashah90 — Wed, 09 Oct 2013 07:35:36 GMT

in properties Sort->Numeric Value

Re: Sorting calculated dimension

tresB — Wed, 09 Oct 2013 07:49:39 GMT

If your sort order is fixed as Nov, Dec, Jan... Then in the sort tab select your calculated dimension and write in expression : =Match(Month_Name, 'Nov','Dec', 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct')

If this does not work, please share your sample app.

Re: Sorting calculated dimension

bbi_mba_76 — Wed, 09 Oct 2013 07:53:11 GMT

Hi, you have to add the year, I think Nov and Dec are 2012, whereas the other month are related to 2013.

Re: Sorting calculated dimension

CELAMBARASAN — Wed, 09 Oct 2013 08:13:03 GMT

You can use something like

IF($(v_OVar1) = 0,

Dual(Month_Name& '-' &

Left(

[Month],4), [Month])..

Re: Sorting calculated dimension

prasadreddy — Wed, 09 Oct 2013 08:52:59 GMT

Hi tresesco,

I tried this, but still it is showing order like:

Feb, Mar, Jan, Dec, Nov,