topic ordering a dimension in QlikView

ordering a dimension

Wed, 08 Feb 2012 13:50:59 GMT

I have created a chart with a grouped dimension

which is 0 1-10 11-20 21-30 31-40 41-50 51-56 57-70 70-90 91-120 121+

however the dimension on the graph is showing as 0 1-10 11-20 121+ 21-30 31-40 41-50 51-56 57-70 70-90 91-120

any ideas on how to solve this problem so that it is in the correct order of 0 1-10 11-20 21-30 31-40 41-50 51-56 57-70 70-90 91-120 121+ ?

Thanks

Laura

ordering a dimension

avastani — Wed, 08 Feb 2012 13:58:14 GMT

Create a second field in that INLINE table called DimensionSortOrder

LOAD * INLINE[

Dimension, DimensionSortOrder

a, 1

b, 2

];

in the chart, do an expression sort on the dimension using the DimensionSortOrder.

ordering a dimension

Wed, 08 Feb 2012 14:00:19 GMT

i tried this but it didnt work, as the dimension is a calculated dimension

ordering a dimension

jagan — Wed, 08 Feb 2012 14:05:13 GMT

Hi,

If this values "0 1-10 11-20 21-30 31-40 41-50 51-56 57-70 70-90 91-120 121+" are static create an inline table like

Interval Order

0 1-10 1

11-20 2

Now in sort tab use the Load order.

Regards,

Jagan.

ordering a dimension

avastani — Wed, 08 Feb 2012 14:05:34 GMT

Calculated Dimension is never a good idea unless absolutely required to. Can you not use an INLINE table and build the Dimension? Calc Dims are the hardest on performance and drag the app down.

ordering a dimension

Wed, 08 Feb 2012 14:09:44 GMT

i need to use a calculated dimension and it hasnt brought the performance time down.

Is there no way of doing this with a calculated dimension?

ordering a dimension

avastani — Wed, 08 Feb 2012 14:13:36 GMT

There probably is and I recall having done one long long time ago.

Somehow you need to assign it a numeric value at the same time that it is a text value i.e. like the DUAL() function.

DUAL is used in script but I can't remember what I did to solve this riddle. are you in v11? if so, try adding a dummy dimension that is hidden and sort the table on that hidden dimension.

ordering a dimension

jagan — Wed, 08 Feb 2012 14:21:58 GMT

Hi,

Can you attach sample file.

Regards,

Jagan.