Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
you should go the properties of each object, choose customized colors and color by expression:
and on the expression part, you can use RGB() function, to set differents colors on each barchart object
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.
I'm talking about two different excel sheets
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
Where do i create flags ?
on the script, on the Load part
is it clear ?