topic Re: Chart Colours in QlikView

Chart Colours

kevbrown — Thu, 07 Jul 2016 10:01:10 GMT

Really simple question I'm sure. In Qlikview I have a number of bars on a chart, I want them all to be the same colour. I could change each of the colours 1-6 on the colour tab but I was wondering if there's a quicker way to do it like in Sense

Re: Chart Colours

sunny_talwar — Thu, 07 Jul 2016 10:04:13 GMT

Try giving a color on the expression tab (look at the image below)

Re: Chart Colours

Chanty4u — Thu, 07 Jul 2016 10:09:22 GMT

as simple as

jsut load one excel with ur same colur rgb and numb... and try below code.. the entire document u wil get same colur

ColorCodes:

LOAD ColorNo,

ColorCode

FROM

[$(vFilePath)\ColorCodes.xlsx]

(ooxml, embedded labels, table is Sheet1);

Let vNumberOfRows = NoOfRows('ColorCodes');

For vI = 0 to (vNumberOfRows - 1)

Let vVariable_Name = Peek('ColorNo',vI,'Expression');

Let [$(vVariable_Name)] = Peek('ColorCode',vI,'Expression');

DROP Table ColorCodes;