Back ground colour

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

As per the expression shown below, it produces percentages. I need to assign back ground colour where percentage grater than 10% or less tan -10% to be assigned with red if not green. But the results are not produced as expected. I have used ' OR function & percentage just marked as 10 & -10. Due to what error it could be?

Thanks

Neville

IF((SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}YTD_ACT)-SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT)-(SUM({<DESCRIPTION={'NET RETAINED PREMIUM'}>}YTD_ACT)-SUM({<DESCRIPTION={'NET RETAINED PREMIUM'}>}MONTH_ACT)))/(SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}YTD_ACT)-SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT))-(SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT)-SUM({<DESCRIPTION={'NET RETAINED PREMIUM'}>}MONTH_ACT))/SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT)>10 OR (SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}YTD_ACT)-SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT)-(SUM({<DESCRIPTION={'NET RETAINED PREMIUM'}>}YTD_ACT)-SUM({<DESCRIPTION={'NET RETAINED PREMIUM'}>}MONTH_ACT)))/(SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}YTD_ACT)-SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT))-(SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT)-SUM({<DESCRIPTION={'NET RETAINED PREMIUM'}>}MONTH_ACT))/SUM({<DESCRIPTION={'GROSS WRITTEN PREMIUM'}>}MONTH_ACT)<10,LIGHTRED(),LIGHT(GREEN)

Re: Back ground colour

chrismarlow — Tue, 28 Aug 2018 15:59:23 GMT

It is not something like you need to use 0.1 and -0.1 for 10% & -10%?

Regards,

Chris.

topic Back ground colour in QlikView

Back ground colour

Re: Back ground colour