Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Not easy to answer.
Do you have Amount values without a KEY relation?
And NULL suppressed in the dimension property of your table chart?
Check your Load statement or the expressions in your qlikview app.
Hi Mario,
looks fine to me? Why is this post titles SET ANALYSIS, am I missing something?
HTH Andy
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
Hi Mario,
here is an example where I get the same result 97545,60
best reagards
chris
Hi,
Works fine for me. Are you sure dont have any selection made?
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.