Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to Flag my debt vs sales Table base on 3 condition ?

Hi All

Many people have help me create the Debt Vs Sales Table using the below link :-

https://community.qlik.com/thread/233169

Now I need add one mor column Flag each row base on below condition :-

1) If  sales = 0  Flag as Very High risk

2) If Debt > Sales Flag as High risk

3) if sales > Debt Flag as Low risk

So user is able to view the customer belong to which risk classification.

Paul

1 Solution

Accepted Solutions
sunny_talwar

May be this:

If(Column(1) > 0, If(Column(2) = 0, 'Very High Risk',

If(Column(1) > Column(2), 'High Risk', 'Low Risk')))

View solution in original post

6 Replies
paulyeo11
Master
Master
Author

my qvw

sunny_talwar

May be this:

If(Column(1) > 0, If(Column(2) = 0, 'Very High Risk',

If(Column(1) > Column(2), 'High Risk', 'Low Risk')))

paulyeo11
Master
Master
Author

Hi Sunny

Thank you , it work.

PAul

paulyeo11
Master
Master
Author

Hi Sunny

One more quick question, may I know how to make

Very High Risk text Color red Color .

High Risk text Color organ Color .

Low risk text Colour Green Color.

Paul Yeo

Director

www.tdstech.com<http://www.tdstech.com>

HP+6285883521036 Indo

sunny_talwar

‌May be use an if statement for the background color of your new expression (you can also use Pick Match combination)

If(Column(4) = 'Very High Risk', Red(),

If(Column(4) = 'High Risk', ....., .....))

paulyeo11
Master
Master
Author

Hi Sunny

Thank it work.

Paul