Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Union not working in QV 9?

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?

2 Replies
Not applicable
Author

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.

Not applicable
Author

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!