topic Re: paint text red if in QlikView

paint text red if

Wed, 19 Oct 2016 06:01:16 GMT

I want to paint a table red and bold if they reach 1/12 percent difference.

=if(Sum({1<OrderYearMonth = {$(selectedYearMonth)}>}LineTotal)/Sum({1<OrderYearMonth = {$(YearSelected)}, OrderYearMonth>}LineTotal) - 1) < 8.3, RGB(255, 128, 128))

It says me that the last part of my script is not right. What could it be there?

thanks in advance

Re: paint text red if

sunny_talwar — Wed, 19 Oct 2016 17:13:21 GMT

Are these two expressions working and giving correct values?

Sum({1<OrderYearMonth = {$(selectedYearMonth)}>}LineTotal)

Sum({1<OrderYearMonth = {$(YearSelected)}, OrderYearMonth>}LineTotal)

If it is, try this:

=If(Sum({1<OrderYearMonth = {$(selectedYearMonth)}>}LineTotal)/Sum({1<OrderYearMonth = {$(YearSelected)}, OrderYearMonth>}LineTotal) - 1) < 0.083, RGB(255, 128, 128))

Re: paint text red if

Sun, 23 Oct 2016 08:00:08 GMT

Those formules give correct values.

=If(Sum({1<OrderYearMonth = {$(selectedYearMonth)}>}LineTotal)/Sum({1<OrderYearMonth = {$(YearSelected)}, OrderYearMonth>}LineTotal) - 1) < 0.083, RGB(255, 128, 128))

this value gives error in this section:

=If(Sum({1<OrderYearMonth = {$(selectedYearMonth)}>}LineTotal)/Sum({1<OrderYearMonth = {$(YearSelected)}, OrderYearMonth>}LineTotal) - 1) < 0.083, RGB(255, 128, 128))

It gives me error in the expression in the place as in my previous formule.

How can this be resolved?

In the attachment you can find a printscreen and the doc.

Merci

Re: paint text red if

sunny_talwar — Mon, 24 Oct 2016 05:41:59 GMT

I think you have these extra parenthesis here:

=If(Sum({1<OrderYearMonth = {$(selectedYearMonth)}>}LineTotal)/Sum({1<OrderYearMonth = {$(YearSelected)}, OrderYearMonth>}LineTotal) - 1) < 0.083, RGB(255, 128, 128))

Once you remove this, you should be fine

=If(Sum({1<OrderYearMonth = {$(selectedYearMonth)}>}LineTotal)/Sum({1<OrderYearMonth = {$(YearSelected)}, OrderYearMonth>}LineTotal) - 1 < 0.083, RGB(255, 128, 128))