Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

ravindraa
Contributor

To get multiple colors in chart


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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: To get multiple colors in chart

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.

View solution in original post

7 Replies
MVP & Luminary
MVP & Luminary

Re: To get multiple colors in chart

See attached qvw.


talk is cheap, supply exceeds demand
Highlighted
ravindraa
Contributor

Re: To get multiple colors in chart

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.

suresh_rawat
Contributor II

Re: To get multiple colors in chart

Hi,

Check the attached QVW.

Regards

Suresh

MVP & Luminary
MVP & Luminary

Re: To get multiple colors in chart

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.

View solution in original post

vardhancse
Valued Contributor III

Re: To get multiple colors in chart

In expression->We can give the colors required.

Expression->Expand->Background Color->Definition

multicolor.jpg

ravindraa
Contributor

Re: To get multiple colors in chart

Thank you very much Gysber Wassenaar,

Now it is working fine

ravindraa
Contributor

Re: To get multiple colors in chart


HI Jagan Mohan,

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