# New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$400 before Dec 31st: REGISTER NOW!
cancel
Showing results for
Did you mean:
Creator

## Color by Background/ text Color expression

Hi,

I have a pivot table in which I calculated the measure using expression :

=Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD))-1

to get the growth rate. I want to color the text Red if below 20%, Amber if between 20%-60% and Green if above 60%.

But since this measure is not a column, I am unable to change the color of it using the regular color by expression function.

How can I achieve this?

I created a master item but of the above formula and called it % change in Sales but unable to get the right code.

1 Solution

Accepted Solutions
Creator II

Hi,

Try as below -

If(

((Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD)))-1) < 0.2, rgb(229,122,122),

If(((Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD)))-1) > 0.2 and

((Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD)))-1) > .6, rgb(229,100,100), green()

)

)

Thanks,

RT

4 Replies
Creator II

Hi,

There is background and text color expression option available in measure of pivot chart. I guess, you can use if condition there.

Thanks,

RT

Creator III

Master

May be your expression like this:

=Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD))

And for Text Color change:

=If((Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD))) < 20%, rgb(229,122,122),

If((Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD))) > 20% and

(Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD))) > 60%, rgb(229,100,100), green())

Creator II

Hi,

Try as below -

If(

((Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD)))-1) < 0.2, rgb(229,122,122),

If(((Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD)))-1) > 0.2 and

((Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD)))-1) > .6, rgb(229,100,100), green()

)

)

Thanks,

RT

Tags
Community Browser