# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for
Did you mean:
Specialist

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

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()))

1 Solution

Accepted Solutions
Creator III

Hi Nevellie,

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

6 Replies
Creator III

Hi Nevellie,

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

Specialist
Author

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

Creator III

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

Specialist
Author

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

Regds

Neville

Creator III

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

Regards,

Akshaya

Specialist
Author

Thank very much Akshya

Look forward to same response in due course

Regds

Neville

Community Browser