topic Can the formula (count when one of the conditions is met) not use the aggr function? in QlikView

Can the formula (count when one of the conditions is met) not use the aggr function?

Nora104 — Wed, 25 Nov 2020 16:16:04 GMT

The formula is as follows, Stores that meet either SO_Qty>0 or SOH_Qty>0 are counted:

count(distinct AGGR(IF(SUM(SO_Qty)>0 or SUM(SOH_Qty)>0,Store_Name,),Store_Name))

Are there other formulas that can be written without the aggr function?

MayilVahanan — Tue, 20 Oct 2020 08:39:41 GMT

Try like below

=Count({<StoreName= {"=SUM(SO_Qty)>0 or SUM(SOH_Qty)>0"}>}DISTINCT StoreName)

and also, you can reduce your formula like below

Sum(AGGR(IF(SUM(SO_Qty)>0 or SUM(SOH_Qty)>0,1),Store_Name))