Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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!

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Set Analysis Less then

Try the intersection operator:

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

4 Replies
MVP
MVP

Re: Set Analysis Less then

Try the intersection operator:

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

Not applicable

Re: Set Analysis Less then

Thanks, it works!

MVP
MVP

Re: Set Analysis Less then

Hi,

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

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


Regards,

Jagan.

anantmaxx
Contributor III

Re: Set Analysis Less then

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

of how * works you made it clear !!

Big Thanks

Community Browser