Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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