Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try class function
youtube.com/watch?v=x3vcIoMGEcU
=class(Dimension,10,'Text')
Feeling Qlikngry?
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
Would you be able to share some sample lines of data with your expected output??