topic Re: Pivot - Background Color in QlikView

Pivot - Background Color

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

Hi All,

Please guide me how to achieve the below one

Chart Type : Pivot

Background condtion : =if(Name='A',Green(),Yellow())

Dimension Background Color is working fine if it is in row format

If we drag ID dimension horizontally the background color is not working

my output should be

Thanks in advance

Re: Pivot - Background Color

sunny_talwar — Thu, 03 Nov 2016 12:57:17 GMT

Try unchecking 'Suppress Zero-Values' on the presentation tab and that should fix the issue

Re: Pivot - Background Color

Anonymous — Thu, 03 Nov 2016 13:01:29 GMT

Thanks Sunny ,

Worked perfectly

Regards,

sam

Re: Pivot - Background Color

Anonymous — Thu, 03 Nov 2016 14:16:00 GMT

Hi,

The same scenario above but with different condition

Back ground color condition : =if(sum(Sales) > 200,Green(),Yellow()) working if it is in row format

dragging ID dimension horizontally , back ground color is not working

Thanks in advance

Re: Pivot - Background Color

sunny_talwar — Thu, 03 Nov 2016 14:17:40 GMT

Did you uncheck 'Suppress Zero-Values' for this chart?

Re: Pivot - Background Color

Anonymous — Thu, 03 Nov 2016 14:24:10 GMT

Hi Sunny,

Yes un checked zero values in presentation tab..

Regards,

sam

Re: Pivot - Background Color

sunny_talwar — Thu, 03 Nov 2016 14:33:00 GMT

Would you be able to share a sample to test this out?

Re: Pivot - Background Color

Anonymous — Thu, 03 Nov 2016 14:41:40 GMT

Hi Sunny,

Sample Data

LOAD * INLINE [
Name, Id, Sales
A, 1, 100
B, 2, 200
C, 3, 300
];

Chart : Pivot

Dimension : Name, ID -> Horizontal

Background Color : Name -> if(sum(Sales) > 200,Green(),Yellow())

Expression : Sum(Sales)

Suppress Zero value - un checked

Regards

Sam

Re: Pivot - Background Color

sunny_talwar — Thu, 03 Nov 2016 14:47:58 GMT

Try this:

=If(Aggr(NODISTINCT Sum(Sales), Name) > 200, Green(), Yellow())

Re: Pivot - Background Color

Anonymous — Thu, 03 Nov 2016 15:42:40 GMT

Hi Sunny,

Thanks , perfect..

Regards,

Sam