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

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

paulyeo11 — Sun, 25 Sep 2016 12:28:06 GMT

Hi All

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

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 — Sun, 25 Sep 2016 12:38:29 GMT

my qvw

sunny_talwar — Sun, 25 Sep 2016 13:11:27 GMT

May be this:

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

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

paulyeo11 — Sun, 25 Sep 2016 13:16:48 GMT

Hi Sunny

Thank you , it work.

PAul

paulyeo11 — Sun, 25 Sep 2016 13:23:12 GMT

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 — Sun, 25 Sep 2016 13:30:13 GMT

‌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 — Sun, 25 Sep 2016 13:45:12 GMT

Hi Sunny

Thank it work.

Paul