Skip to main content

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 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
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
adityaakshaya
Creator III
Creator III

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

View solution in original post

6 Replies
adityaakshaya
Creator III
Creator III

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

nevilledhamsiri
Specialist
Specialist
Author

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

adityaakshaya
Creator III
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

nevilledhamsiri
Specialist
Specialist
Author

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

Regds

Neville

adityaakshaya
Creator III
Creator III

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

Regards,

Akshaya

nevilledhamsiri
Specialist
Specialist
Author

Thank very much Akshya

Look forward to same response in due course

Regds

Neville