topic Set Union not working in QV 9? in QlikView

Set Union not working in QV 9?

Wed, 01 Jul 2009 13:56:47 GMT

Hi,

I'm testing a document made for 8.5 in 9.

It uses a variant of the sample found here.

The problem is that every expression of the type:

sum({Set1 + Set2 + Set3} someField) (where Set1, 2 and 3 are bookmarks)

seems to work on Set1 only, without adding them.

So, sum({Set1 + Set2 + Set3} someField) seems equivalent to sum({Set1} someField).

Could anyone confirm this? Or it's just me?

Wed, 01 Jul 2009 14:17:11 GMT

Hi,

i used the same sample and i created a text object with the following expression:

=Sum ({Set1 + Set3 + Set2} Quantity)

The results seem to be correct. If the Set1 includes both Set2 and Set3, then the result is the same as for Set1 only, as expected.

If the Sets are disjoint then the result is the sum of the quantities of the three sets.

it appears to be working Ok.

Wed, 01 Jul 2009 14:23:47 GMT

Thank you!

I just wanted to be sure.

So it must be something else... Maybe the format of the bookmarks?

Gotta go check...

Many many thanks for your ultra-quick response!