Is it possible to use dynamic segment size in linear jauge in Pivot table)

[#1]

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

[Miguel_Angel_Baeyens · Accepted solution]

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

[#3]

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