topic Conditional Formatting in a ARRAY in QlikView

Conditional Formatting in a ARRAY

Fri, 04 Dec 2015 11:43:21 GMT

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

Re: Conditional Formatting in a ARRAY

maxgro — Fri, 04 Dec 2015 17:31:03 GMT

maybe a pivot

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

Re: Conditional Formatting in a ARRAY

omerfaruk — Fri, 04 Dec 2015 17:49:40 GMT

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.