topic Logic Calculation in QlikView

Logic Calculation

krish2459 — Sat, 16 Nov 2024 20:10:40 GMT

Hi,

We a have below requirement which was posted as image.

Actually I thought of instead of therotical explanation it very better to expalin with an example of what we need.

Please go thorugh with the image below and attached sample work book.

Thanks..

krish2459 — Thu, 29 Aug 2019 14:13:21 GMT

Hi ,

Any Inputs to crack the logic.

Thanks..

Anil_Babu_Samineni — Thu, 29 Aug 2019 14:29:08 GMT

Perhaps this?

Count({<Product={"=Sum(Aggr(count(Product), Product))=$(=Count(Distinct My))"}>} Product)

krish2459 — Thu, 29 Aug 2019 15:01:57 GMT

Hi Anil,

I'm getting blanks by using the logic you posted.

Thanks..