topic Set Analysis with Multiple Conditions in QlikView

Set Analysis with Multiple Conditions

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

I am trying to count the distinct item ids that the quantity is greater than 0 and have a margin greater Than $150.

Issue is that it ignores the quantity of greater than 0. When I get my results I see that it is includes negative Quantities. When answers should show Margin that is greater than 150 and quantities that are greater than 0.

The formula is

,Count({<ITEM_ID={"=Sum(QUANTITY) > 0"},ITEM_ID={"=SUM(CTF)/SUM(QUANTITY)>150"}

>} distinct ITEM_ID)

Any advice would be greatly appreciated been spending days trying to figure it out. I even created in the script a column that identifies

positive and negative Flag and tried to that into the expression with no success

Thanks

Re: Set Analysis with Multiple Conditions

sunny_talwar — Fri, 17 Aug 2018 16:20:41 GMT

May be try this

Count({<ITEM_ID = {"=Sum(QUANTITY) > 0 and SUM(CTF)/SUM(QUANTITY)>150"}>} DISTINCT ITEM_ID)

Re: Set Analysis with Multiple Conditions

Anonymous — Fri, 17 Aug 2018 19:29:36 GMT

Thank you so much, I know is was getting close. I was making it more complicated than needed.

Re: Set Analysis with Multiple Conditions

sunny_talwar — Fri, 17 Aug 2018 19:52:01 GMT