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

[paulyeo11]

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

[paulyeo11]

my qvw

[sunny_talwar · Accepted solution]

May be this:

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

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

[paulyeo11]

Hi Sunny

Thank you , it work.

PAul

[paulyeo11]

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]

Hi Sunny

Thank it work.

Paul