Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm using a linear jauge in a pivot table. the min of a segment is an expression.
It's doesn't seems to work , except if I select exactly one line in my chart
(please see example in attachment).
I'd like to know if it's a bug or if there is another way to do it.
Best regards
Hi Bertrand,
Similarly to how set analysis works, the limits are for the total chart, and not value by value. There is an open idea here so QlikView allows you to do that value dynamic. You will have to play with the Text Color property of the expression (expand clicking the [+] button at the left of the expression), using a condition. For example
If(Sum(Valeur) >= Sum(Objectif), LightGreen(), LightRed())
Regards,
Miguel
Hi Bertrand,
Similarly to how set analysis works, the limits are for the total chart, and not value by value. There is an open idea here so QlikView allows you to do that value dynamic. You will have to play with the Text Color property of the expression (expand clicking the [+] button at the left of the expression), using a condition. For example
If(Sum(Valeur) >= Sum(Objectif), LightGreen(), LightRed())
Regards,
Miguel
Hi Miguel,
this answer is not a good news for me ,
but at least I doesn't need to look any further
Thanks for your help
Regards