Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
sofiavaz
Contributor II

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

Re: set of values in set analysis

May be this

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

View solution in original post

10 Replies

Re: set of values in set analysis

May be this

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

View solution in original post

sofiavaz
Contributor II

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

sofiavaz
Contributor II

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?

sofiavaz
Contributor II

Re: set of values in set analysis

I can not for confidential reasons.. Thank you

Re: set of values in set analysis

ok

sofiavaz
Contributor II

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?

Re: set of values in set analysis

May be try to add an equal sign before your variable

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

or this

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