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

[#1]

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

[Anonymous]

Can you upload a sample qvw???

[#3]

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...!!!

[#4]

Hi Priya Sane

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

[#5]

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.

[#6]

I have tried. Qlikview says Error

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

[#7]

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.

[#8]

Hi,

Try:

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

in sorting Expression and select ascending.

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

[MK_QSL · Accepted solution]

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

[#10]

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.