topic Background colour in QlikView

Background colour

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

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)

)))))

Thanks..

neelamsaroha157 — Fri, 16 Dec 2016 16:37:55 GMT

can you provide some sample data

joseduque — Fri, 16 Dec 2016 16:42:53 GMT

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

Anonymous — Fri, 16 Dec 2016 16:45:16 GMT

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

Anonymous — Fri, 16 Dec 2016 16:47:00 GMT

Simulate a case where all columns are not null.

nareshthavidishetty — Fri, 16 Dec 2016 17:01:06 GMT

Hi,

It is because of the first row is null.

Let me know how to get this.

Thanks..

nareshthavidishetty — Fri, 16 Dec 2016 17:45:38 GMT

Hi,

Below logic in expression fix the issue.

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

Thanks..