Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pivot Table - Dimension colour formatting

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

SourceMonthValue
AOct

0

Nov2
Dec2

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.

CJ

1 Solution

Accepted Solutions
Not applicable

Re: Pivot Table - Dimension colour formatting

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)

)

5 Replies
Highlighted
er_mohit
Honored Contributor II

Re: Pivot Table - Dimension colour formatting

try this in background color of Source.

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

whiteline
Honored Contributor II

Re: Pivot Table - Dimension colour formatting

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.

Not applicable

Re: Pivot Table - Dimension colour formatting

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
Honored Contributor II

Re: Pivot Table - Dimension colour formatting

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.

Not applicable

Re: Pivot Table - Dimension colour formatting

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