topic Re: To get multiple colors in chart in QlikView

To get multiple colors in chart

ravindraa — Wed, 29 Oct 2014 11:05:54 GMT

Hi all,

I have struck one place Please help me , my requierment is i have to maintain two Y-axies in single chart as well as i have to show the one caliculation value on each Bar.

To create this i am using combo chart , i am getting correct values but the problem is if i maintain the 2 expressions

1.it is not allowing Multi color option .

2. The first chart is not showing Caliculation values.

please give me any suggesion on this.

Thanks in advance

please find the attachments.

Re: To get multiple colors in chart

Gysbert_Wassenaar — Wed, 29 Oct 2014 13:19:44 GMT

See attached qvw.

Re: To get multiple colors in chart

ravindraa — Thu, 30 Oct 2014 04:07:19 GMT

Hi Gysbert Wassenaar,

I have seen your attached document but you have removed the other Y-axies in my chart ,we need two Y-axes in the chart Based on the 2nd Y-axies the caliculated value has to be display in the each bar.

Please give me any suggession .

Thanks in advance.

Re: To get multiple colors in chart

suresh_rawat — Thu, 30 Oct 2014 04:33:53 GMT

Hi,

Check the attached QVW.

Regards

Suresh

Re: To get multiple colors in chart

jagan — Thu, 30 Oct 2014 06:44:22 GMT

Hi,

Try like this

Chart Properties -> Expressions -> Click on Expression -> Click on + symbol and give below expression

=Pick(RowNo(), Blue(), Red(), Green(), Black(), Magenta(), RGB(100, 100, 100), RGB(200, 200, 200))

Hope this helps you.

Regards,

jagan.

Re: To get multiple colors in chart

vardhancse — Thu, 30 Oct 2014 06:49:48 GMT

In expression->We can give the colors required.

Expression->Expand->Background Color->Definition

Re: To get multiple colors in chart

ravindraa — Thu, 30 Oct 2014 08:10:28 GMT

Thank you very much Gysber Wassenaar,

Now it is working fine

Re: To get multiple colors in chart

ravindraa — Thu, 30 Oct 2014 08:12:16 GMT

HI Jagan Mohan,

Thank you very much for helping, Now it is working fine .