topic Re: Set Analysis Less then in QlikView

Set Analysis Less then

Thu, 12 Dec 2013 10:32:20 GMT

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!

swuehl — Thu, 12 Dec 2013 10:34:31 GMT

Try the intersection operator:

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

Thu, 12 Dec 2013 10:36:54 GMT

Thanks, it works!

jagan — Thu, 12 Dec 2013 10:37:22 GMT

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 — Thu, 12 Dec 2013 10:44:22 GMT

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

of how * works you made it clear !!

Big Thanks