Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
employe4_2
Contributor III
Contributor III

if statement with calculated field

Hi

i'm trying to display a scatter plot with  bubbles of color, wich  are function of average value of the bubble.

If its above its green if its not its red. I use this expression trying to do that 

 2019-03-06_16h15_20.pngBut ain't working

2019-03-06_16h13_20.pngtried with : [End.of.Position.]> 3,2 and there it work.

So i guess it's coming from dynamic value, what do i miss?

 

thx

2 Replies
Gysbert_Wassenaar

Try: If( [End.of.Position.]> avg({1} TOTAL [End.of.Position.]), ...etc

talk is cheap, supply exceeds demand
employe4_2
Contributor III
Contributor III
Author

thanks ! indeed it work

can you explain to me why TOTAL make it work ?

i don't understand why it act like this

 

thx