# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for
Did you mean:
Partner

## Using colors for Master measure for conditional values

Hello guys!!

Need your help on below case.

I have a requirement where i wanted to show text with measure value and i also want the measure value to be given in colors according to my condition. Since the data is confidential im providing you with sample.

Eg: My sales Increased by 10%( 10million from 5million in May'19 (Take previous month))

now 10% should be shown in green colour when current sale is greater than previous month sale and it should show red when previous sale is greater than current month sale.

I even tried adding as master measure but i can give either the whole text in same color or if i use segment color i must add limit where i need to enter value manually.. ( this value takes few expressions with so many conditions in my case) which will not work.

This must be shown as Single measure only.

-Nive

Labels (1)
• ### Color for measure

3 Replies
Partner

in ur chart, color by expression:

assume ur measure is :sum (Sales)

the color would be sthing like:

if(sum(Sales) >= above(sum(Sales)),green(),red())

per analogy:

Partner
Author
Thanks Omar. but my requirement is to bring text with measure values as a KPI only
"My sales Increased by 10%( 10million from 5million in May'19)"
only 10% should have the colour changes.
Partner

Same logic :

if(
(sum( Sales)

- above(
sum( Sales))) / above(
sum( Sales)) >0.1

,green(),red())

Result:

Or increase by 10% or more : green

0 to 10% : grey

decrease : red

if(

sum(Sales)< above(sum(Sales)),red(),

if((sum( Sales)

- above(
sum( Sales))) / above(
sum( Sales)) >0.1

,green(),'grey'))

Result: