Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

Challenge Color Background dimension (on a pivot table)

Hi,

I came across with a problem to set the background color of 2 dimensions of pivot table based on their max value.

I have attached a qvw file to help.

My pivot table:

Imag1.PNG.png

What I need:

Imag2.PNG.png

Can anyone please help me to accomplish that.

Thanks in advance,

CAFC

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Challenge Color Background dimension (on a pivot table)

Try expression like this:

=if(Type=only({<Type={"=rank(aggr(sum({< Article={'AAA'}>}Value),Type))=1"}>}Type) ,red())

regards

Darek

View solution in original post

5 Replies
Highlighted
Not applicable

Re: Challenge Color Background dimension (on a pivot table)

Try expression like this:

=if(Type=only({<Type={"=rank(aggr(sum({< Article={'AAA'}>}Value),Type))=1"}>}Type) ,red())

regards

Darek

View solution in original post

Highlighted
Partner
Partner

Re: Re: Challenge Color Background dimension (on a pivot table)

Dariusz hit the nail on the head (and beat me to it!)  If you would like your example back with Background Colors populated, it is attached.

Highlighted
Not applicable

Re: Re: Challenge Color Background dimension (on a pivot table)

I know, i prepared similiar one.

Only one thing i'am not sure - try to add listbox for size and then select one value. Why total is green?

Highlighted
Contributor

Re: Challenge Color Background dimension (on a pivot table)

thanks to you guys! it works nice!

Highlighted
Partner
Partner

Re: Re: Challenge Color Background dimension (on a pivot table)

Dariusz does bring up a good point.  Is the filtered total coloring going to cause issues?