Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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!

1 Solution

Accepted Solutions
sunny_talwar

May be this

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

View solution in original post

10 Replies
sunny_talwar

May be this

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

Anonymous
Not applicable
Author

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
Not applicable
Author

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
Not applicable
Author

I can not for confidential reasons.. Thank you

sunny_talwar

ok

Anonymous
Not applicable
Author

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)))"}