topic Re: Unique colors for chart legends -- Urgent help in QlikView

Unique colors for chart legends -- Urgent help

Sat, 21 Jul 2012 09:02:55 GMT

Hi All,

I have a requirement where I have to show different Unique colors for the legends in the charts..

For Eg: I have a chart which has a drill downs Department,Location and Skills.By default the chart show Department view and the legend with the different Department values which should have unique colors and same with the Location and Skills.In the same way where ever the Department is used in the other chart I want to see the same color reflected over all the charts.

Please let me know if anyone has suggestions..

Thanks in advance

Re: Unique colors for chart legends -- Urgent help

khadeer — Sat, 21 Jul 2012 09:51:28 GMT

In colors tab check persistent color check box.

Regards,

Khadeer

Re: Unique colors for chart legends -- Urgent help

Mon, 23 Jul 2012 04:52:27 GMT

Hi,

I have tried it but it dnt work.

Re: Unique colors for chart legends -- Urgent help

Mon, 23 Jul 2012 04:53:40 GMT

Hi All,

Any suggestion??

Re: Unique colors for chart legends -- Urgent help

brenner_martina — Mon, 23 Jul 2012 07:16:22 GMT

Hi,

1. you can use in color tab document colors defined and work there with variables: vcolor1 = RGB(0,0,0)

2. you can work with if-then-else statements in background color (click at +-sign in expression) and also work with variables

Greetings

Martina

Re: Unique colors for chart legends -- Urgent help

Mon, 23 Jul 2012 07:20:33 GMT

Hi Martina,

Could you please provide me a sample application if possible.

Thanks in advance

Re: Unique colors for chart legends -- Urgent help

brenner_martina — Mon, 23 Jul 2012 07:31:13 GMT

Hi,

here is an example

Greetings Martina

Re: Unique colors for chart legends -- Urgent help

Wed, 25 Jul 2012 09:45:39 GMT

Hi Martina,

thanks for providing an example but this works fine when you have a single dimension but not for the Drill dowm group.Could you please let me know if you have any suggestions for the Drill down group dimension colors.

Thanks in advance..

Re: Unique colors for chart legends -- Urgent help

brenner_martina — Thu, 26 Jul 2012 07:15:43 GMT

Hi,

there is a nice function:

If(GetCurrentField([Groupname])='XYZ',true,false)

Does this help?

Greetings from Munich

Martina

Re: Unique colors for chart legends -- Urgent help

Fri, 27 Jul 2012 04:27:18 GMT

Hi Martina,

Ya I am aware of it but I dnt want to manually check for the Values in the different dimensions of the drill down to put unique colors.

Thanks

Lavanya