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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analysis totalling specific

Hi,

I'm trying to total amounts for specific unit of measures using set analysis, but when I plug in my expression my numbers are too large.

For instance, if I narrow my selection to return 1 row and the VALUE is 100 for USD, my expression will return something completely wrong like 67432.

Here's my expression:

=num(sum({<UOM = {'USD'}>}VALUE))

Can anyone help me with this or point me in the right direction?

1 Reply
swuehl
MVP
MVP

Hard to tell from the information you posted. Any chance that you upload a small sample QVW that demonstrates your issue?