topic Re: How do I Set Sort Order in chart with Calculated Dimension? in QlikView

How do I Set Sort Order in chart with Calculated Dimension?

Tue, 08 Apr 2014 05:56:37 GMT

I have created a chart with calculated DImension

The chart shown below

The calculated Dimension is as follows

=Replace(class(POINTS,$(vClassVol)),'<= x <', ' - ')

How do I set the sort order so that the 50-100 after 0-100

Thank you

Re: How do I Set Sort Order in chart with Calculated Dimension?

Anonymous — Tue, 08 Apr 2014 06:00:45 GMT

Can you upload a sample qvw???

Re: How do I Set Sort Order in chart with Calculated Dimension?

Tue, 08 Apr 2014 06:11:36 GMT

Go to the sort tab, and for calulated dimension click on

Numeric value--> Ascending option.

I t will automatically sort the calulated dimension as per the numenric values.

Hope this will help you...!!!

Re: How do I Set Sort Order in chart with Calculated Dimension?

Tue, 08 Apr 2014 06:15:17 GMT

Hi Priya Sane

Thanks I have tried. The result as follow. I am not getting the correct chart

Re: How do I Set Sort Order in chart with Calculated Dimension?

Tue, 08 Apr 2014 06:21:13 GMT

Could you try the same sort for Numeric value by removing the 'Replace' clause in your calculated dimension and check whether its working or not.

Re: How do I Set Sort Order in chart with Calculated Dimension?

Tue, 08 Apr 2014 06:25:34 GMT

I have tried. Qlikview says Error

The dimension as follows ==(class(POINTS,$(vClassVol)),'<= x <', ' - ')

Re: How do I Set Sort Order in chart with Calculated Dimension?

Tue, 08 Apr 2014 06:28:47 GMT

write

class(POINTS,$(vClassVol)) as calculated dimension and try

or the other option is write your same expression you have written in calculated dimension in your Sort tab--> Expression field.

Re: How do I Set Sort Order in chart with Calculated Dimension?

Tue, 08 Apr 2014 06:32:45 GMT

Hi,

Try:

=Replace(class(POINTS,$(vClassVol)),'<= x <', '0')

in sorting Expression and select ascending.

i.e replace '<= x <' with 0 in sorting expression.

Re: How do I Set Sort Order in chart with Calculated Dimension?

MK_QSL — Tue, 08 Apr 2014 06:33:18 GMT

Try below as calculated dimension

=DUAL(Replace(class(POINTS,$(vClassVol)),'<= x <', ' - '),class(POINTS,$(vClassVol)))

Now go to sort expression and use Number by Ascending or Descending Order

Re: How do I Set Sort Order in chart with Calculated Dimension?

Tue, 08 Apr 2014 06:45:48 GMT

Priya,

I have tried using the calculated dimension expression in sort expression. I am getting the same chart as what I posted in my first request

How ever if I use the expression class(POINTS,$(vClassVol)) It does solves but the x axis labeling is different

Thanks. Manish suggestion worked the way I want. Your suggestion is alternate.

Re: How do I Set Sort Order in chart with Calculated Dimension?

Tue, 08 Apr 2014 07:02:27 GMT

Could you please explain why Dual function is used here and what exactly Dual function does??

Re: How do I Set Sort Order in chart with Calculated Dimension?

MK_QSL — Tue, 08 Apr 2014 07:06:02 GMT

=DUAL(Replace(class(POINTS,$(vClassVol)),'<= x <', ' - '),class(POINTS,$(vClassVol)))

Dual Function is Storing Data as String and Number both format.

1st Part Replace(class(POINTS,$(vClassVol)),'<= x <', ' - ') as String

and 2nd Part class(POINTS,$(vClassVol)) as Number

Now when you sort by number it will consider the second part.

Why I use Dual ?

Class Function is storing data as Numeric Format but when you tried Replace, it will converted to text/string format.

If you try only class(POINTS,$(vClassVol)) in class format without replace, you can sort the data by the same sorting method I have described above, but due to replace function now it will not work.

Hope this will help..

Re: How do I Set Sort Order in chart with Calculated Dimension?

Wed, 09 Apr 2014 00:10:33 GMT

Thanks Manish. Nice of you giving detailed explanation. This makes understanding much better and easy. Appreciate