topic Re: Count of Product_IDs That have been sold in all days for a Selected Month. in QlikView

Count of Product_IDs That have been sold in all days for a Selected Month.

israrkhan — Sat, 16 Nov 2024 18:47:30 GMT

Dear Community,

requesting your help to write an expression.

Requirement is,

i want to get only those Product_IDs where sold Qty is greater than 0, in All Days for a selected Month.

let say the user have selected March-2020, then i need to count only those Product_IDs, whom have sale in all 31 days of march.

for a comparison purpose i have to consider only those Product_IDs who have sale in all days for a selected month.

appreciate your help.

Many Thanks.

Re: Count of Product_IDs That have been sold in all days for a Selected Month.

tresB — Mon, 13 Apr 2020 10:55:16 GMT

You could probably use set analysis. But that would majorly depend on your data/model. Could you share a sample app and explain the expected output in tat context?

Re: Count of Product_IDs That have been sold in all days for a Selected Month.

Brett_Bleess — Wed, 13 May 2020 19:42:46 GMT

Along the lines of the prior post, here is a Design Blog post that will likely be helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

There are some related links at the bottom of the post, just FYI.

Regards,
Brett