10 Replies Latest reply: Nov 13, 2017 11:10 AM by Sofia Vaz

# set of values in set analysis

Hi all!

Do you know if can I have something like this:

Count({<Product=[100,...,322]>}Sales)

Instead of describing all of my products between 100 and 322...?

Thank you!

• ###### Re: set of values in set analysis

May be this

Count({<Product = {'>=100<=322'}>}Sales)

• ###### Re: set of values in set analysis

Thank you,

In fact, what I have is a code for the current week of the year (different from the usual number). I want to analyze from week 1 to the one we are in now so I needed something like this:

AllocWeekYear={'>=1 <= 'Only({<AllocDate={'\$(=Date(Today(),'DD-MM-YYYY'))'}>}AllocWeekYear)''}

but it's not working... do you have any idea what i might be doing wrong?

• ###### Re: set of values in set analysis

May be this

AllocWeekYear={">=1<=\$(=Only({<AllocDate={'\$(=Date(Today(),''DD-MM-YYYY''))'}>} AllocWeekYear)''}

• ###### Re: set of values in set analysis

Like that AllocWeekYear and AllocDate aren't recognized as fields and only, date an today as functions

• ###### Re: set of values in set analysis

Would you be able to share a sample?

• ###### Re: set of values in set analysis

I can not for confidential reasons.. Thank you

• ###### Re: set of values in set analysis

ok

• ###### Re: set of values in set analysis

If I use this:

AllocWeekYear={">=1<=45"}, the expressions works well.

If I use this, AllocWeekYear={">=1<=(\$(vCurrentAllocWeek))"}, where vCurrentAllocWeek it's a variable =max({<AllocDate={'\$(=Date(Today(1),'DD-MM-YYYY'))'}>}AllocWeekYear), the expressions doesn't work..

That's everything I can share... do you have any idea what might be the problem?