topic Re: Pivot Table - Dimension colour formatting in QlikView

Pivot Table - Dimension colour formatting

Fri, 22 Feb 2013 12:01:08 GMT

I'm currently trying to colour a dimension on a pivot table as below.

I want to have the source turn red when the value per source exceeds 3, however because the value is split by month the colour is not applying.

Thanks in advance.

er_mohit — Fri, 22 Feb 2013 12:08:01 GMT

try this in background color of Source.

aggr(if(Value>3,red())Value)

whiteline — Fri, 22 Feb 2013 12:26:44 GMT

Hi.

If you mean "value in any month of source exceeds 3", try this as a background color expression for Source dimension:

=if(Min(aggr(Value>3, Source, Month)), red(), null())

I assumed that you have two dimensions Source and Month.

Fri, 22 Feb 2013 14:49:24 GMT

I was looking for the sum of source, not the individual months... with some looking up of the aggr function I have what I need

this gives me the amount per source

aggr(sum(Value),Source)

and the accompanying if statement

If(

aggr(sum(Value),Source)

>3,

rgb(200,10,10)

)

whiteline — Fri, 22 Feb 2013 15:57:28 GMT

In this case the "total" statement is useful to discard some dimensions:

If(sum(total<Source> Value) >3, rgb(200,10,10))

This will also work for Month dimension.

Wed, 13 Jul 2016 02:44:27 GMT

Hi:

I want to color code my dimension field (and dimension only) based on the value of the dimension (not the value of the expression).

Is this possible?

Also, where can I find the background color expression for dimension? I can only find the background color expression for expressions.

Thank you very much.

Paco