Re: Set Analysis Expression - Qlik Community

Surya · ‎2020-02-26

Hello,

Please Help in Set Analysis Expression.

If(So_Bill_Balance > 0,

Sum(billQty))

How can i write in Set Analysis.

jonathandienst · ‎2020-02-27

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))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Brett_Bleess · ‎2020-03-31

See related post: https://community.qlik.com/t5/QlikView-App-Development/Help-Set-Analysis-Expression/m-p/1679688#M449...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.