Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Not applicable

Flag Debt Amt more then L8M Sales customer as risky customer

Hi All

How to Flag when Debt more then Sales ? i am able to create the script in table.

When I try below script for partial load , it return error :-

((Sum(if(Month_n<'8',sales)))-(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren)) >0,Yes) as Flag,

So that i can flag customer who debt more then sales as risky customer.

Paul