Chart Colours

[kevbrown]

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

[sunny_talwar · Accepted solution]

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

[Chanty4u]

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');

Next

DROP Table ColorCodes;