Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Color by expression

Hi,

I was wondering whether you guys knew how to color data in bar charts different colors depending on which sheet the data comes from.

For example would i like to color data in a bar chart from sheet1 Yellow and data from sheet1-1 gray.

6 Replies
YoussefBelloum
Champion
Champion

Hi,

you should go the properties of each object, choose customized colors and color by expression:

barchart.png

and on the expression part, you can use RGB() function, to set differents colors on each barchart object

petter
Partner - Champion III
Partner - Champion III

Are you talking about a sheet in Qlik Sense or a sheet in an Excel workbook?

Qlik Sense does not organize it's data in the data model by sheet like Excel does. So any sheet in Qlik Sense can use the same data model - the entire data model.

Anonymous
Not applicable
Author

I'm talking about two different excel sheets

YoussefBelloum
Champion
Champion

You can create flags on the tables load like this:

Table1:

load

.

'Sheet1' as Flag,

.

From ...Sheet1...

after you can do what i have mentioned above, like this:

if(Flag='Sheet1', rgb(X,X,X) ) on the coloring expression

Anonymous
Not applicable
Author

Where do i create flags ?

YoussefBelloum
Champion
Champion

on the script, on the Load part

is it clear ?