need calculated dimension for my scenario

[#1]

hi all

            in my scenario i need to develop a barchart the expression for that barchart is

           sum()/sum(2nd dimension)*100 its working fine. in dimension i need to add calculated dimension

   if that expression>0 and <10 tha values shown between 0-10 else 10-20 else 30-40 like that i need  standard dimesion

the values in the dimension like 0 10 20 30 40 50 60 70 80 90 >90

if expression<10 it should bars between 0-10 else 10-20 .......>90

! ! here red mark is dimension it should be standard .

please find the below attachment  here expression is sum(orders)/sum(quota)*100

i need dimension like which is cover with red mark 0% 10% like that the dimension should  be standard

thanks

[robert_mika]

Try class function

youtube.com/watch?v=x3vcIoMGEcU

=class(Dimension,10,'Text')

Feeling Qlikngry?

How To /Missing Manual(18 articles)

[#3]

hi robert thanks for your replay but here no dimension based on the expression we need to calculated the standard dimension

expression is sum(dimensio1)/sum(dimension2)*100

i need dimension for that expression  dimension should show 0% 10% 20% 30% ...90% if expression is less than 10% those bar wll shown between 0-10 in tamesion like that i need dimension for expression

[sunny_talwar]

Would you be able to share some sample lines of data with your expected output??