Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a stright table.with in that i hve multiple expressions.
So my requirmnt is in that table there is diff between Planned Vs actual value >10 it shud be dispaly red
<5 green in beetwen 5 to 10 it show yellow.
it is ging exactly...
but i need to dispaly one indictor on top as GO:LIVE:- Red() or Green() or yellow() [This colur is based on stright table colour.
1)if any one of colur is red---- live status shud be red
2)if all green ----Live green
3)if all yellow-----Lie yellow?
How can achive this?
Go to Solution.
You can use textbox and images
Where vStat is a calculated variable.
You can use aggr() and variable.
Somthing like that:
if(sum(Planned)-sum([actual value])>10, 1,
if(sum(Planned)-sum([actual value])>5, 2, 3
Where Dim1, Dim2 are your dimensions in your straight table.
So you will have 1 for red, 2 for yellow, 3 for green.
And you will be able this value to get colour.
i need to show in top one textbox object?
based on below table if red it wil show red lik dat?