topic Re: Set Analysis Expression in QlikView

Set Analysis Expression

Surya — Sat, 16 Nov 2024 01:10:41 GMT

Hello,

Please Help in Set Analysis Expression.

If(So_Bill_Balance > 0,

Sum(billQty))

How can i write in Set Analysis.

jonathandienst — Thu, 27 Feb 2020 05:09:33 GMT

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

Brett_Bleess — Tue, 31 Mar 2020 21:12:52 GMT

Regards,
Brett