topic Background color in QlikView

Background color

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

Hello,

I have a pivot table and a dimmension called Scenario, and on this dimension I used Background color like this:

=if(Scenario = 'B',rgb(165,219,147),if(Scenario='R',rgb(232,208,232),rgb(252,101,29)))

The problem is that it applies the color only sometimes on 'B' scenario.

'R' and 'A' scenarios remain without background color and I can't understand why.

Thank you!

Re: Background color

Chanty4u — Fri, 03 Jun 2016 11:46:15 GMT

its fine here chk below

Re: Background color

simonagheo — Fri, 03 Jun 2016 12:38:10 GMT

I need the background color to be set directly on dimension (in the dimension tab), like this:

=if(c1=2009,rgb(165,219,147),if(c1=2010,rgb(232,208,232),rgb(252,101,29)))

Re: Background color

santiago_respane — Fri, 03 Jun 2016 12:47:30 GMT

Hi Simona,

your expression looks fine to me, I created a qv app with dummy data with same dimenion name and some values, copied your expression as it is and worked.

Maybe you can verify if there's a space or something in your Scenario dimension values. If that's the case you can use trim to compare.

Also you can share your app with dummy data in order to resolver your issue faster.

Hope this helps.

Kind regards,

Re: Background color

Fri, 03 Jun 2016 19:03:18 GMT

Use same expression in Dimension Background color in Dimension Tab

Re: Background color

simonagheo — Thu, 25 Aug 2016 08:59:47 GMT

It seems like if the first row of the pivot table has no value in the Database for that scenario, it won't calculate the dimension color.

I found a solution: to generate lines for all dimensions with no values. I don't know that this is the best solution but it works.