Conditional Formatting in a ARRAY

[#1]

Hi all and thanks in advance for your help

i have got a user dashboard built in Excel to create in Qlikview.

i have to reproduce the exact same thing...

there's an arraw such as a Pivot Table with a conditional format such as :

is there a built in feature i didn't find ?

or an extension ?

Thank you

[maxgro]

maybe a pivot

for bar, an expression with linear gauge as display options, something like (bar and number are different expressions)

[omerfaruk]

You can do this with a pivot table.

Under expression tab, you should select Linear Gauge from display options. In the Gauge settings select mode Fill to Value. You would have two segments. Segment 1 lower bound 0, segment 2 lower bound should be same as your expression. Min= 0 and Max is the highest possible value(again expression). Remember to uncheck Autowidth segments check box in gauge settings.

However you might not be able to show text and the colour under the same column.