Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a table as follow
I would like to use Visual cues and change the color of labors as follow
Go to Solution.
What I would suggest, is, instead of using Visual Cues, to use the expression attributes.
In front of every expression on the expressions tab, there is a small plus sign.
If you click on it, you can see the expression attributes.
Select the Text Color for the Labors expression and type the following expression:
if(System_Type='Type1' AND sum_of_labors>210, lightred(), green())
you would be best using back ground colour formatting against your expression, see example attached.
This has as back ground colour expression of:
if(System_Type='Type1' AND sum(Labors>210), lightred(), if(System_Type='Type2' AND sum(Labors>95), lightred(), LightGreen()))
On the Sum(Labors) expression that gives the following results:
Thanks you I use your recommandation