Discussion Board for collaboration related to Creating Analytics for QlikView.
I want to set the image which should be change based on certain condition..
I have calculated growth in my application and when growth is greater than 0 then it should display upword Arrow image and
if growth is less than 0 it should display downward Arrow image.
How should i do this?
My expression is:
I have tried this expression but im not able to get image it returns the string in 'if' condition that i have wrote..
Plzz help me
Thanks in advance.
Try below code:
Please use the below code in Expressions Tab of chart
Num(Sum(Sales)/Sum(Target)-1, '▲ 0.0%;▼ 0.0%')
Also write the below code for Back Ground color as
If(Sum(Sales) > 0, '▲ 0.0%;▼ 0.0%')
But instead of that arrow which you have placed in expression i want image ..
if growth >0 it should be green upword arrow else red downward arrow image..