set analysis

[mario-sarkis]

hey all

I have this table, the problem is if i put these value on excel the total amout will be 97545.60 but if i put SUM(Amount) on a text box on qlik it giving me a diffrent answer wich is 292636.80 can you help ?

KEY                            Amount

5043|20140620	1386.4013266998
5081|20140425	564.51077943615
5088|20140425	159.86733001658
5092|20140425	92.868988391376
5404|20140222	1109.1210613599
5869|20140920	267
5869|20140920	399
6284|20140624	49.751243781095
6286|20140624	257.04809286899
6442|20140920	22000
6442|20140920	20000
6442|20140920	16500
6442|20140920	20000
6442|20140920	8500
6613|20140620	4975.1243781095
6701|20140705	1284.9087893864

[swuehl]

Not easy to answer.

Do you have Amount values without a KEY relation?

And NULL suppressed in the dimension property of your table chart?

[krishna_2644]

Check your Load statement or the expressions in your qlikview app.

[awhitfield]

Hi Mario,

looks fine to me? Why is this post titles SET ANALYSIS, am I missing something?

HTH Andy

[anbu1984]

I am getting 97545.60 in QV. Check this app

Seems like your input is duplicated(292636.80/97545.60 = 3). Can you post your script

[#6]

Hi Mario,

here is an example where I get the same result 97545,60

best reagards

chris

[fvelascog72]

Hi,

Works fine for me. Are you sure dont have any selection made?

[jonathandienst]

If I load that table into Qlikview I get 97545.6. I suggest you post a sample of your qvw so that we can see why you are getting the larger total.