Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
qlikviewsam
Contributor

Pivot - Background Color

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

Tags (1)
1 Solution

Accepted Solutions

Re: Pivot - Background Color

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

9 Replies

Re: Pivot - Background Color

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

qlikviewsam
Contributor

Re: Pivot - Background Color

Thanks Sunny ,

Worked perfectly

Regards,

sam

qlikviewsam
Contributor

Re: Pivot - Background Color

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

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

qlikviewsam
Contributor

Re: Pivot - Background Color

Hi Sunny,

Yes un checked zero values in presentation tab..

Regards,

sam

Re: Pivot - Background Color

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

qlikviewsam
Contributor

Re: Pivot - Background Color

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

Try this:

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

qlikviewsam
Contributor

Re: Pivot - Background Color

Hi Sunny,

Thanks , perfect..

Regards,

Sam