Specific Colors for Products and chart defaults for remaining products

[#1]

Hi All,

I have a requirement as 4 Bussiness units ( in cyclic group)out of which 3 have distinct colors which have been mentioned in an excel sheet.

The remaining one i want it to get chart default colors. For other dimensions in cyclic group we want chart to take chart default colors.

But i get back black color for anything other than the 3 business units mentioned.

I have followed this Blog : https://community.qlik.com/blogs/qlikviewdesignblog/2012/12/04/colors-in-charts

Find sample qvw attached.

Any Help appreciated.

Thanks

Khushboo

[Gysbert_Wassenaar]

See attached example.

[#3]

Thanks a lot for our solution Gysbert.

But 4th Business Unit, i.e Toolings i want that also to use default colors and not black.

Can we have a solution for that?

[Gysbert_Wassenaar · Accepted solution]

=If(GetCurrentField([Cyclic_Dims])='Business Unit',alt(ProductColor,color(fieldindex('Business Unit',[Business Unit]))),

color(fieldindex( $(=chr(39) & GetCurrentField([Cyclic_Dims]) & chr(39) ), $(='[' & GetCurrentField([Cyclic_Dims]) & ']' ) ))

)

[#5]

This is an excellent solution.

One last query on above .

Can we implement this without Apply Map and mapping. Can we just implement this using inline load?

[Gysbert_Wassenaar]

Yes, I don't see why not.

[#7]

Because when i try to use direct inline the 4th business unit again comes in black color.

See attached QVW.

[qlikviewwizard]

Hi,

I think the issue is with back ground color definition.

[#9]

I have used inline load and was able to color. thanks a ton for that

But all other colors in the chart i want them to come as the color palette i have given but it comes as default color

palette.

Any idea how can i use the color which we have given.

[sundarakumar]

Couldnt completely understand the question. is it about the other charts or the other entries in the same chart?