Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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)

)

View solution in original post

5 Replies
er_mohit
Master II
Master II

try this in background color of Source.

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

whiteline
Master II
Master II

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
Author

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)

)

View solution in original post

whiteline
Master II
Master II

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
Author

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