Sum of sales of all products - Qlik Community

niranjana · ‎2022-02-09

Hi,

I wrote this expression :

sum(aggr(sum( {< Product={"=Sum(PrevTL)=0"},Year={"$(=Year(Max(Date)))"},Month={"<=$(=Num(Month(Max(Date))))"},flag={'Onco'}>} TL_Value),Product,[Ret/Hosp]))

But it gives TLValue i.e. sales only for one product. There are 3 such products. Any help is appreciated.

Thanks

Niranjana

PrashantSangle · ‎2022-02-09

what is your dimension?

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

niranjana · ‎2022-02-12

Dimension is Company.

And I must show sum of sales of all products falling under that company whose prev year sales is zero.

But Product is not the dimension.

Thanks,

Niranjana