Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
nareshthavidishetty
Contributor III

Background colour

Hi,

I have used the below code to get the background colour,but for few codes the background colour is not came .

Code:

=if(Category='CS',rgb(196,191,191),

if(Category='CK',rgb(196,191,191),

if(Category='MC',rgb(196,191,191),

if(Category='VS',rgb(196,191,191),

if(Category='DI',rgb(196,191,191)

)))))

Untitled.png

Thanks..

Tags (1)
1 Solution

Accepted Solutions
nareshthavidishetty
Contributor III

Re: Background colour

Hi,

Below logic in expression fix the issue.

Logic: if(sum(sales)>0,sum(sales)), which replace zero's with null.

Thanks..

View solution in original post

6 Replies
neelamsaroha157
Valued Contributor II

Re: Background colour

can you provide some sample data

Partner
Partner

Re: Background colour

Thats because CK, MC and DI are no the same name that the one in the field. Check for lower cases or the value.

marcioarruda
Contributor III

Re: Background colour

Is not it because you only have value in the first two columns?

marcioarruda
Contributor III

Re: Background colour

Simulate a case where all columns are not null.

nareshthavidishetty
Contributor III

Re: Background colour

Hi,

It is because of the first row is null.

Let me know how to get this.

Thanks..

nareshthavidishetty
Contributor III

Re: Background colour

Hi,

Below logic in expression fix the issue.

Logic: if(sum(sales)>0,sum(sales)), which replace zero's with null.

Thanks..

View solution in original post