Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Please Help in Set Analysis Expression.
If(So_Bill_Balance > 0,
Sum(billQty))
How can i write in Set Analysis.
Set analysis is a filter, not a conditional, so you cannot implement if(...sum()) type expressions using set analysis.
If what you really meant was
Sum(If(So_Bill_Balance > 0, billQty))
which is not the same thing, then this could be done using:
Sum({<So_Bill_Balance = {">0"}>} billQty))
See related post: https://community.qlik.com/t5/QlikView-App-Development/Help-Set-Analysis-Expression/m-p/1679688#M449...
Regards,
Brett