Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rammuthiah
Contributor II

Color by Expression

I have 1 dimension, 2 measures.

I want the color based on 2 meaures like count(Late) and count(Not Late) shown below. By applying Multicolor option, it is coming as like below. When I am changing color based on expression like : if count - Late, show in as red and if count  - Not Late, show in as green.

Also sorting problem based on match function. It is not sorting accordingly.

Any idea??

color Community.JPG

Message was edited by: RAM MUTHIAH M

1 Solution

Accepted Solutions
vijetasharma
Contributor III

Re: Color by Expression

create master item for you these two measure and give respective colors to master measure and now replace these two measure with your existing measures in chart

and now in your chart appearance properties make colors as auto

7 Replies
vijetasharma
Contributor III

Re: Color by Expression

what is your exact requirement? which colors you want for count(late) and count(not late)

rammuthiah
Contributor II

Re: Color by Expression

count(Late) - Red

Count(Not Late) - Green

vijetasharma
Contributor III

Re: Color by Expression

I think in Qliksense it's not possible to customize color by measure. and if you use by dimension it will give you blue and red color as above screenshot.

vijetasharma
Contributor III

Re: Color by Expression

create master item for you these two measure and give respective colors to master measure and now replace these two measure with your existing measures in chart

and now in your chart appearance properties make colors as auto

ogster1974
Honored Contributor II

Re: Color by Expression

Why not make your measure a master item and set the colour of it there

rammuthiah
Contributor II

Re: Color by Expression

Anyhow the above one worked for me. Thanks for your reply

ogster1974
Honored Contributor II

Re: Color by Expression

no problem glad it helped.

Community Browser