topic Re: Using If statements to set colors in App Development

Using If statements to set colors

Mch201 — Sat, 16 Nov 2024 17:33:28 GMT

I am trying to set colors of the bars based on the difference between target and actual sales. but the problem I am having is that if the difference is exactly 5, the color will be blue otherwise it will show gray. even though the code says if (Avg(Targets)- (Avg([Sales])) >= 5, then set blue as the color. it only show blue when the difference is EXACLTY 5. how do i fix this?

=If(Avg(Targets)- (Avg([Sales])) >= 10, Yellow(),

If(Avg(Targets)- (Avg([Sales])) >= 15, Red(),

If(Avg(Targets)- (Avg([Sales])) >= 5, LightBlue(),

)))

Re: Using If statements to set colors

edwin — Thu, 28 Jan 2021 18:32:19 GMT

average will result in a real number and not an integer and depending on how you display your data (Qlik Sense rounds it off) so depending on your precision, add fraction to force it to round up in your if statement. you will need to test this fraction (format your expression to show more decimal points so you know what you are dealing with)

also test for >=15 before testing for >=10 as it is Red will never show

Re: Using If statements to set colors

Ksrinivasan — Thu, 28 Jan 2021 18:35:08 GMT

hi,

you have to set between ranges as below

If(Avg(Targets)- Avg([Sales])) >= 10 and (Avg(Targets)- Avg([Sales])) <= 15, Yellow(),

ksrinivasan

Re: Using If statements to set colors

PradeepK — Thu, 28 Jan 2021 19:12:45 GMT

Use Below Code for reference..

if( $(vActual) >=15 ,Red() ,if( $(vActual) >=10 ,Yellow() ,if( $(vActual) >= 5 ,blue() ,Black() // for all values less than 5 ) ) )

Where vActual is variable holding calculation condition

Avg(Targets)- Avg(Sales)

Also @edwin is right! Be aware of the code execution flow.