How to get back pie default colors in qlikview after coloring 2 slices

[Anonymous]

In the background expression for color after setting few slices as red, green, amber based on a condition, I would like all other pie slices to have the color from the pallette. - color tab - instead of one color for all new pie slices. basically for all new pie slices as the pie chart grows I want it to take colors from the color tab from the pie chart instead of having one color for all new pie slices.

[Anonymous]

Any response to this persistent colors not working for color row no()

[jyothish8807]

Hi Trail,

Check this. Now i have added a unique serial number corresponding to each dimension and i am using the serial number to control the color from the pallet.

Br,

KC

[rwunderlich]

Jyothish,

You can avoid the need to assign serial numbers by using FieldIndex() function.

color(FieldIndex('Product', Product))

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Anonymous]

Thank you but Is there a function we can use directly in the background color like you showed first rather than adding it to the script giving us the desired result of persistent colors. Send me a solution.

[jyothish8807]

Hi Rob,

Thanks for your suggestion and help

Br,

KC

[jyothish8807]

Hi Trail,

As suggested by Rob use field index to avoid creating field in the script.

=if(Product='A',red(),if(Product='B',Green(),color(FieldIndex('Product', Product))))