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

Challenge Color Background dimension (on a pivot table)

cafcptg2011 — Fri, 16 May 2014 21:42:09 GMT

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:

What I need:

Can anyone please help me to accomplish that.

Thanks in advance,

CAFC

Fri, 16 May 2014 22:35:10 GMT

Try expression like this:

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

regards

Darek

aaronnash — Fri, 16 May 2014 22:49:54 GMT

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.

Fri, 16 May 2014 22:56:04 GMT

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?

cafcptg2011 — Fri, 16 May 2014 23:18:35 GMT

thanks to you guys! it works nice!

aaronnash — Fri, 16 May 2014 23:20:35 GMT

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