Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

napac1458
Contributor II

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?

Tags (1)
1 Reply
MVP
MVP

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