topic Re: set of values in set analysis in App Development

set of values in set analysis

Anonymous — Mon, 13 Nov 2017 12:29:44 GMT

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

sunny_talwar — Mon, 13 Nov 2017 12:56:36 GMT

May be this

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

Re: set of values in set analysis

Anonymous — Mon, 13 Nov 2017 14:25:58 GMT

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

sunny_talwar — Mon, 13 Nov 2017 14:29:49 GMT

May be this

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

Re: set of values in set analysis

Anonymous — Mon, 13 Nov 2017 14:47:37 GMT

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

Re: set of values in set analysis

sunny_talwar — Mon, 13 Nov 2017 14:49:10 GMT

Would you be able to share a sample?

Re: set of values in set analysis

Anonymous — Mon, 13 Nov 2017 15:00:18 GMT

I can not for confidential reasons.. Thank you

Re: set of values in set analysis

sunny_talwar — Mon, 13 Nov 2017 15:02:49 GMT

Re: set of values in set analysis

Anonymous — Mon, 13 Nov 2017 15:39:03 GMT

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?

Re: set of values in set analysis

sunny_talwar — Mon, 13 Nov 2017 15:48:30 GMT

May be try to add an equal sign before your variable

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

or this

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

Re: set of values in set analysis

Anonymous — Mon, 13 Nov 2017 16:10:01 GMT

I've tried only like this AllocWeekYear={"<=$(vCurrentAllocWeek)"} and it works! Thank you!