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

Set Analysis Less then

Hi all,

I have a set analysis to sum all sales before weeknumber 40 (40 is the result of a variable).

SUM( {$< WeekNumber = { '<= $(vLastWeek)' } >} Amount)

Now it selects all sales before week 40, also when I select in a Listbox weeks 10-20.

Which set analysis should I use?

Thanks!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try the intersection operator:

SUM( {$< WeekNumber *= { '<= $(vLastWeek)' } >} Amount)

View solution in original post

4 Replies
swuehl
MVP
MVP

Try the intersection operator:

SUM( {$< WeekNumber *= { '<= $(vLastWeek)' } >} Amount)

Not applicable
Author

Thanks, it works!

jagan
Luminary Alumni
Luminary Alumni

Hi,

For this try intersection operator * like this, it takes intersection of Current selection and Set Analysis expression

=SUM( {$< WeekNumber *= { '<= $(vLastWeek)' } >} Amount)


Regards,

Jagan.

Anonymous
Not applicable
Author

Thanks jagan for explanation i new the use of + and - operator but was not aware

of how * works you made it clear !!

Big Thanks