topic Re: SET Analysis Possible or Exclude in App Development

SET Analysis Possible or Exclude

gertjanvanluik_ — Sat, 16 Nov 2024 17:34:42 GMT

Hi all,

I have a question about SET Analysis with the Possible or Exclude function. I've a set of sales per month. Each month a set of products. I want to know how many products I sold in previous period, but NOT in the current period. So I want to use the Exclude function. When I want to know how many products are not sold in Period 2, I use this code:

count( distinct {$< Product = E( {$< Month = {2} >} ) >} Product )

But I want this for a rolling year. In period 2 I want to compare it with period 1, in period 3 with period 2 etc.

Pls. can you help me?

Re: SET Analysis Possible or Exclude

GaryGiles — Tue, 26 Jan 2021 10:41:11 GMT

Try this:

count({$<Year={$(=Year(AddMonths(Today(),-1)))},Month={$(=num(month(AddMonths(Today(),-1))))},
Product=E({$<Year={$(=Year(Today()))},Month={$(=Num(Month(Today())))}>} Product)>} distinct Product)

You need to use the Addmonths with Year() and Month() to account for December to January.

Re: SET Analysis Possible or Exclude

gertjanvanluik_ — Wed, 27 Jan 2021 07:04:27 GMT

Hi @Anonymous,

Thank you for your solution. This is not were I was looking for. I want a solution where I have a table with dimension month and then every month the missing products in that month, compared with the previous month.

Look at my attachment for a the model.