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: 
rammuthiah
Creator III
Creator III

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
vijetas42
Specialist
Specialist

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

View solution in original post

7 Replies
vijetas42
Specialist
Specialist

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

rammuthiah
Creator III
Creator III
Author

count(Late) - Red

Count(Not Late) - Green

vijetas42
Specialist
Specialist

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.

vijetas42
Specialist
Specialist

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
Partner - Master II
Partner - Master II

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

rammuthiah
Creator III
Creator III
Author

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

ogster1974
Partner - Master II
Partner - Master II

no problem glad it helped.