topic Re: Color Coding in Pivot Chart in QlikView

Color Coding in Pivot Chart

ZoeM — Wed, 25 Nov 2020 16:16:04 GMT

Hi Comunity.

I am trying to color code the Items in the month section of the Pivot table and I am unable to color code the concatenated items (see attachment). I have tried using a combination in the formatting under Expressions and I could not get it to work. Do I need to create a wildcard item?

[Cans,Scrapers]

Re: Color Coding in Pivot Chart

sunny_talwar — Tue, 19 Jun 2018 18:21:46 GMT

Try this

=If(Count(DISTINCT Item) > 1, LightRed())

Re: Color Coding in Pivot Chart

ZoeM — Tue, 19 Jun 2018 18:27:35 GMT

Can I specify by combination? So if it Cans,Scrapers vs Trophies,Spades?

Re: Color Coding in Pivot Chart

sunny_talwar — Tue, 19 Jun 2018 18:37:44 GMT

Not sure I understand, can you elaborate?

Re: Color Coding in Pivot Chart

ZoeM — Tue, 19 Jun 2018 20:26:56 GMT

The method you specified when I applied it in my workbook changed all the different concatenated types. Am I able to specify which concan=tenated types should be a specific color?

Scraper,Trophies = RGB(100,150,200)

Cans,Scrapers = RGB(255,200,150)

Re: Color Coding in Pivot Chart

sunny_talwar — Wed, 20 Jun 2018 00:02:47 GMT

Try this

=If(Concat(DISTINCT Item,',') = 'Cans,Scrapers', RGB(255,200,150),

If(Concat(DISTINCT Item, ',') = 'Scrapers,Trophies', RGB(100,150,200)))

Re: Color Coding in Pivot Chart

ZoeM — Wed, 20 Jun 2018 12:17:23 GMT

You are just a genius Sunny, and a valid asset to the community!

You have no idea how I have suffered to get that together

Re: Color Coding in Pivot Chart

ZoeM — Wed, 20 Jun 2018 12:59:42 GMT

Am I able to have a two color gradient within the cells?

I noticed that in the Styles tab in Properties I can have two gradient colors but it did not take effect when enabled. Also, in the Custom Format Cells right click option, it is disabled (greyed out).

I would like to see if I can have two colors for the fields that are concatenated: A diagonal gradient showing the two colros split for th eitem.

Any ideas?