topic Re: How back ground colour is designed for the satisfaction of two expressions? in QlikView

How back ground colour is designed for the satisfaction of two expressions?

nevilledhamsiri — Tue, 08 May 2018 17:36:41 GMT

Hi Members,

Appreciate if reference is made to case where two conditions to be met if that is to be ok if not needs to be treated as not ok. I wish to show this in back ground colour. Simply what I need is something like below!

If UPR & DAC balances are both negative, such cases are ok. Similarly if UPR & DAC balances are both positive still it is alright but if the combination is the opposite such as (one is positive whereas other is negative & so on) then they are not alright & need to show red in colour. The expression used is as follows. but it doesn't show me the expected out put. Please help.

IF(Sum (UPR) AND SUM(DAC)<0,LightGreen(),IF(Sum (UPR) AND SUM(DAC)>0,LightGreen(),LightRed()))

Re: How back ground colour is designed for the satisfaction of two expressions?

adityaakshaya — Tue, 08 May 2018 18:12:34 GMT

Hi Nevellie,

I downloaded the attachment and it is a blank application.

You can use below expression

IF(Sum (UPR)<0 AND SUM(DAC)<0,LightGreen(),IF(Sum (UPR)>0 AND SUM(DAC)>0,LightGreen(),LightRed()))

Regards,

Akshaya

Re: How back ground colour is designed for the satisfaction of two expressions?

nevilledhamsiri — Tue, 08 May 2018 18:27:00 GMT

Thanks Adithya,

It is alright. If the expected colouring to be highlighted both on UPR & DAC at once , can it be done in single expression such s one you proposed or is it required to apply the same on DAC as well.

Regds

Neville

Re: How back ground colour is designed for the satisfaction of two expressions?

adityaakshaya — Tue, 08 May 2018 18:32:18 GMT

As per my understanding you are using a straight table chart. and you have two measures UPR and DAC.

If the above understanding is correct, then yes, you have to use background color expression in both UPR and DAC.

Regards,

Akshaya

Re: How back ground colour is designed for the satisfaction of two expressions?

nevilledhamsiri — Tue, 08 May 2018 18:52:10 GMT

If it is a Pivot chart, does the answer is same or otherwise

Regds

Neville

Re: How back ground colour is designed for the satisfaction of two expressions?

adityaakshaya — Tue, 08 May 2018 18:55:55 GMT

Yes, You have to add it in both the measures.

Regards,

Akshaya

Re: How back ground colour is designed for the satisfaction of two expressions?

nevilledhamsiri — Tue, 08 May 2018 18:58:30 GMT

Thank very much Akshya

Look forward to same response in due course

Regds

Neville