Qlik Sense - Background color expression not working as expected?

[Mr_Pearl]

Within Chart --> Table I am trying to highlight rows based on the content (string) like below table. By using following expression within "Background color expression"

If(Product='Apple', Yellow(), If(Product='Samsung', Green(), If(Product='Google', Blue(), Red())))

However, I get below output,

If I use my calendar to display only August and July then I get below output,

Meaning only the latest month is getting displayed with right colors. I don't know what am i missing here. Can someone please help. I tried using Pick and match functions but still getting same result.

[rubenmarin · Accepted solution]

Hi, it would be great if we can have a sample to check, looks like something is filtering for the last month.

You can try with: If(Only({1} Product)='Apple', Yellow()... but it's just a guess.

[vikasmahajan]

try with this 

Pick(WildMatch(Product, 'Apple', 'Samsung', 'Google'),'Yellow()', 'Green()', 'Blue()', 'Red()')

[stevedark · Accepted solution]

Hi @Mr_Pearl 

Do you have another column in the table with a calculation? Is there set analysis in that column, showing months that are outside of the current selections?

If that was the case then I would expect the colour expression to behave as you have there.

Code something like this might then fix up the issue:

If(maxstring({1}Product)='Apple', Yellow(), If(maxstring({1}Product)='Samsung', Green(), If(maxstring({1}Product)='Google', Blue(), Red())))

You might also want to define your own colours, using the rgb function, as the stock ones that use the colour name functions are not always great.

Hope that helps.

Steve

[Mr_Pearl]

Thank you @stevedark Your solutions works too.

[Mr_Pearl]

Thank you for your time @vikasmahajan . I tried this before but didnt work.

[Zaouja11]

its works for me thank you rubenmarin