Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Contributor II

Set Analysis totalling specific


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?

Tags (1)
1 Reply

Re: Set Analysis totalling specific

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

Community Browser