topic Re: set analysis in QlikView

set analysis

mario-sarkis — Thu, 28 May 2015 14:05:24 GMT

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

Re: set analysis

swuehl — Thu, 28 May 2015 14:11:45 GMT

Not easy to answer.

Do you have Amount values without a KEY relation?

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

Re: set analysis

Qrishna — Thu, 28 May 2015 14:12:28 GMT

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

Re: set analysis

awhitfield — Thu, 28 May 2015 14:12:47 GMT

Hi Mario,

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

HTH Andy

Re: set analysis

anbu1984 — Thu, 28 May 2015 14:13:58 GMT

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

Re: set analysis

Thu, 28 May 2015 14:15:12 GMT

Hi Mario,

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

best reagards

chris

Re: set analysis

fvelascog72 — Thu, 28 May 2015 14:15:24 GMT

Hi,

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

Re: set analysis

jonathandienst — Thu, 28 May 2015 14:19:11 GMT

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.