Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

restrict bar

Hi @sunny_talwar   @Vegar  @tresesco 

 

i want to restrict  the bar value.  

i have a bar chatrt showing  percentatge  of 

DIm: branch

measure=count(total open value)/count(dtotal dispatch) 

data is showing proper values with  all bars.

 

but  for one branch (pune) its showing 875.0%  as   user dont want to see that much value.. cant we restrict  only for that branch percentage to 100 ?  any suggestions?

 

Labels (1)
8 Replies
Taoufiq_Zarra

@soniasweety like ?

 

if((count(total [open value])/count(total dispatch))>1,1,(count(total [open value])/count(total dispatch)))

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
soniasweety
Master
Master
Author

No luck showing 1 for all bars  😞

Taoufiq_Zarra

can you show me the value of (count(total [open value])/count(total dispatch)) or try this :

if((count(total [open value])/count(total dispatch))>100,100,(count(total [open value])/count(total dispatch)))
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
soniasweety
Master
Master
Author

attached sample

sunny_talwar

Why are you using TOTAL in both your numerator and denominator expression?

Kushal_Chawda

@soniasweety  your expression should look like below. see the attached

=if(sum( open)/sum( distach)>1,0,sum( open)/sum( distach))

soniasweety
Master
Master
Author

Hi kush,

 

i didnt see  pune in your attached file ?  ..

Kushal_Chawda

@soniasweety  It's hidden in bar as % is more than 100