topic Re: Color by expression in App Development

Color by expression

Anonymous — Mon, 22 Jan 2018 09:15:41 GMT

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.

Re: Color by expression

YoussefBelloum — Mon, 22 Jan 2018 09:22:42 GMT

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

Re: Color by expression

petter — Mon, 22 Jan 2018 09:22:44 GMT

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.

Re: Color by expression

Anonymous — Mon, 22 Jan 2018 09:35:17 GMT

I'm talking about two different excel sheets

Re: Color by expression

YoussefBelloum — Mon, 22 Jan 2018 09:38:10 GMT

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

Re: Color by expression

Anonymous — Mon, 22 Jan 2018 09:54:18 GMT

Where do i create flags ?

Re: Color by expression

YoussefBelloum — Mon, 22 Jan 2018 09:59:59 GMT

on the script, on the Load part

is it clear ?