topic Re: Set Analysis totalling specific in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-totalling-specific/m-p/494222#M482378 <HTML><HEAD></HEAD><BODY><P>Hard to tell from the information you posted. Any chance that you upload a small sample QVW that demonstrates your issue?</P></BODY></HTML> Wed, 14 Aug 2013 15:33:54 GMT swuehl 2013-08-14T15:33:54Z Set Analysis totalling specific https://community.qlik.com/t5/QlikView/Set-Analysis-totalling-specific/m-p/494221#M482377 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>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.</P><P>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.</P><P></P><P>Here's my expression:</P><P></P><P>=num(sum({&lt;UOM = {'USD'}&gt;}VALUE))</P><P></P><P>Can anyone help me with this or point me in the right direction?</P></BODY></HTML> Wed, 14 Aug 2013 15:22:26 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-totalling-specific/m-p/494221#M482377 Anonymous 2013-08-14T15:22:26Z Re: Set Analysis totalling specific https://community.qlik.com/t5/QlikView/Set-Analysis-totalling-specific/m-p/494222#M482378 <HTML><HEAD></HEAD><BODY><P>Hard to tell from the information you posted. Any chance that you upload a small sample QVW that demonstrates your issue?</P></BODY></HTML> Wed, 14 Aug 2013 15:33:54 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-totalling-specific/m-p/494222#M482378 swuehl 2013-08-14T15:33:54Z