topic Qlikview different background colors for values in dimension in QlikView

Qlikview different background colors for values in dimension

Mon, 03 Apr 2017 15:37:39 GMT

Hi,

I have a dimension in a pivot table. The dimension has 6 values. I want a different random background colors to distinguish the different values of the dimension. Kindly suggest!

Thanks!

Re: Qlikview different background colors for values in dimension

yoganantha321 — Mon, 03 Apr 2017 15:58:16 GMT

Hi Naveed ,

just go to dimension click on '+' symbol and in background color. Give color for dimension. You can also use conditions based colors.

Re: Qlikview different background colors for values in dimension

yoganantha321 — Thu, 06 Apr 2017 12:57:36 GMT

Hi Naveed,

Did you got the expected output?

Re: Qlikview different background colors for values in dimension

Anil_Babu_Samineni — Thu, 06 Apr 2017 13:13:30 GMT

May be use this?

=Color(FieldIndex('DimensionName',DimensionName))

Re: Qlikview different background colors for values in dimension

Anonymous — Thu, 06 Apr 2017 13:28:35 GMT

If you need to specify the color you have to put condition into background color of your dimension.

But if don't need to put specific color the solution proposed By Anil is the best.

Re: Qlikview different background colors for values in dimension

Thu, 06 Apr 2017 14:12:50 GMT

No Yoganantha

Re: Qlikview different background colors for values in dimension

Anonymous — Thu, 06 Apr 2017 14:15:53 GMT

Did you try the solution proposed by loveisfail ?

If it is not the result expected, please provide a part of your qvw application. It will be easier to help you.