Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

1 Solution

Accepted Solutions
Highlighted

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

View solution in original post

9 Replies
Highlighted

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

View solution in original post

Highlighted
Creator
Creator

Thanks Sunny ,

Worked perfectly

Regards,

sam

Highlighted
Creator
Creator

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

Highlighted

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

Highlighted
Creator
Creator

Hi Sunny,

Yes un checked zero values in presentation tab..

Regards,

sam

Highlighted

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

Highlighted
Creator
Creator

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

Highlighted

Try this:

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

Highlighted
Creator
Creator

Hi Sunny,

Thanks , perfect..

Regards,

Sam