set of values in set analysis

[Anonymous]

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!

[sunny_talwar · Accepted solution]

May be this

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

[Anonymous]

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?

[sunny_talwar]

May be this

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

[Anonymous]

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

[sunny_talwar]

Would you be able to share a sample?

[Anonymous]

I can not for confidential reasons.. Thank you

[sunny_talwar]

ok

[Anonymous]

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?

[sunny_talwar]

May be try to add an equal sign before your variable

AllocWeekYear={">=1<=($(=vCurrentAllocWeek))"}

or this

AllocWeekYear={">=1<=($(=$(vCurrentAllocWeek)))"}