topic Set Analysis Question in QlikView

Set Analysis Question

Thu, 28 May 2009 18:07:55 GMT

hi,

i'm using following function to add some data:

sum( {$<Year=, Month=, YearMonthRolling= {$(=Month + Year * 100)},[Customer]={'10*'}>} Figure)

my selection is:

Year, Month and one Customer which has a 10!

Why is it that this sum adds all customers with a "10"? and not only the one i have selected? with "$" i use also the selected values? am i wrong?

Set Analysis Question

Anonymous — Thu, 28 May 2009 19:06:40 GMT

Hi Corleone,

It is correct that using $ looks at the current selections, but making selections in the Set analysis statement will apply the new selections to the fields.

Example:
I have selected Continent 'Europe' and Country 'Germany'.

sum({$<Country={'France'}>} Sales)

This expression will still look at the sales for France even though my selection in the field Country is Germany.

Set Analysis Question

Thu, 28 May 2009 19:23:45 GMT

ok thx

i guess i missunderstood the help of set analysis!

Set Analysis Question

johnw — Fri, 29 May 2009 01:27:49 GMT

You can still do what you want. You can specify an intersection with the currently-selected customers by using *= instead of = like this:

sum({<Year=,Month=,YearMonthRolling={$(=Month + Year * 100)},Customer*={'10*'}>}Figure)