topic Bar Chart Colour using Expression in QlikView

Bar Chart Colour using Expression

Mon, 22 Jul 2013 07:11:19 GMT

Hi Guys

What is the correct syntax for forcing the colour of my pie chart. Here is my syntax in Expressions>Background Colour:

=If(TravelFlightCompany='BA',vBlue,

if(TravelFlightCompany='Kulula',vGreen,

if(TravelFlightCompany='SAA',vOrange,vGrey)))

Thanks

Re: Bar Chart Colour using Expression

pennetzdorfer — Mon, 22 Jul 2013 07:31:39 GMT

Your expression should work. Do your variables contain equal signs? If not, add "=" to your variables or write variables in your expression like $(vBlue)

Regards,

Florian

Re: Bar Chart Colour using Expression

Mon, 22 Jul 2013 07:31:56 GMT

Hi try this...

Expressions>BackgroundColour:

pick(match(TravelFlightCompany, ' BA', 'Kulula','SAA'),
     rgb(0,0,255),
     rgb(0,128,0),
     rgb(255,128,0)
     )

& colours tab >Data appearance color select grey..

Hope it will help u..

regards-bika

Re: Bar Chart Colour using Expression

Mon, 22 Jul 2013 07:51:18 GMT

HI Bika

Worsk well thanks. Only thing is I am using Dimension Limit, Show Top 5 and Options Show Others. The Colour of my top 5 have been sey by me, but how do I set the colour for the "Other"?

Re: Bar Chart Colour using Expression

Mon, 22 Jul 2013 08:36:30 GMT

colours tab >Data appearance color select grey fpor "others"..

pls try this..but u cant fix inside the others dim...

regards-bika

Re: Bar Chart Colour using Expression

Mon, 22 Jul 2013 08:49:15 GMT

Hi Bika,

Could youtell how to assign document cal to a document as I have 25 document cals in the server

Thanks