topic Re: Qlik Sense: Colour by expression in a bar graph (one dimension & multiple measures) in App Development

Qlik Sense: Colour by expression in a bar graph (one dimension & multiple measures)

rahulgoyal1287 — Thu, 21 Jun 2018 09:45:39 GMT

Hi Everyone,

I am looking for some help in Qliksense.. i have a bar chart which has only one dimension but four measures... i want to give specific colour to each measure(which denotes as bars) by writing it in colour by expression....

I am familiar with the way to do it in such a scenario where we have one or more dimensions & only one measure.. where i can write the expression by using IF Clause.. etc...

It would be great if there is any workaround to do that at expression level which can be shared with me as well.

Thank you in anticipation.

Best Regards,

Rahul Goyal

Re: Qlik Sense: Colour by expression in a bar graph (one dimension & multiple measures)

YoussefBelloum — Thu, 21 Jun 2018 09:51:11 GMT

Hi,

to be able to color by expressions you should set the coloring parameter to multicolour

Re: Qlik Sense: Colour by expression in a bar graph (one dimension & multiple measures)

rahulgoyal1287 — Thu, 21 Jun 2018 10:08:43 GMT

Thanks for the response Youssef.. However i want to give specific colours to specific measures which is is possible by using colour by expression... multicolour would give random colours which i dont want to use.

Re: Qlik Sense: Colour by expression in a bar graph (one dimension & multiple measures)

YoussefBelloum — Thu, 21 Jun 2018 10:11:25 GMT

I see, I've never try coloring by expressions using the coloring expression editor.. I'll take a look but maybe omarbensalem‌ already know how to do this

Re: Qlik Sense: Colour by expression in a bar graph (one dimension & multiple measures)

OmarBenSalem — Thu, 21 Jun 2018 10:30:49 GMT

Create ur 4 measures as master measures (master items); and there u can define a color to each of ur measures:

Re: Qlik Sense: Colour by expression in a bar graph (one dimension & multiple measures)

rahulgoyal1287 — Thu, 21 Jun 2018 10:58:48 GMT

Thank you Omar for the help.. it worked!!