Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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

1 Solution

Accepted Solutions
MVP
MVP

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

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

2 Replies
MVP
MVP

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

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

Not applicable

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

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

Community Browser