topic Re: Manual Calculation versus Expression Calculation Not Matching in QlikView

Manual Calculation versus Expression Calculation Not Matching

pnn44794 — Sat, 12 Oct 2019 21:13:15 GMT

Hello:

I have a straight table and two text boxes. Both text boxes do a Sum of quantity. The straight table is nothing fancy with simply a column name as the sole expression.

When I export the straight table to Excel, filter it exactly as the Text box expressions, I get a different total than what is displayed in the text boxes. For YQUANTITY in that text box I have a total of 444,818, but when I manually sum the Excel export, I get 552,417 or a difference of 107,599. For the XQUANTITY in that text box, I have a total of 737,207, but when manually summed in the Excel export, I get 738,647 or a difference of 1,440.

The two expressions for the text boxes follow. I've also attached some sample data which I've already filtered to match the following expressions.

Does anyone have any ideas what might be causing this? As always, I appreciate any and all help and responses. Thanks in advance.

Re: Manual Calculation versus Expression Calculation Not Matching

sunny_talwar — Tue, 10 Apr 2018 21:54:42 GMT

Is this where you load the data from or is this the export from QlikView?

Re: Manual Calculation versus Expression Calculation Not Matching

pnn44794 — Tue, 10 Apr 2018 23:23:00 GMT

Hello Sunny:

This is the export from Qlikview.

Re: Manual Calculation versus Expression Calculation Not Matching

sunny_talwar — Wed, 11 Apr 2018 00:55:02 GMT

Is it possible that not all of the fields within the table box might be coming from more than a single table?

Re: Manual Calculation versus Expression Calculation Not Matching

pnn44794 — Sat, 12 Oct 2019 21:14:30 GMT

The following is in a Text object and not a table box or am I misunderstanding you (certainly possible on my part)?

Re: Manual Calculation versus Expression Calculation Not Matching

pnn44794 — Sat, 12 Oct 2019 21:15:23 GMT

Sorry. I didn't fully answer. The fields all come from the same table. For the Straight table, the fields come from two tables.

Re: Manual Calculation versus Expression Calculation Not Matching

sunny_talwar — Wed, 11 Apr 2018 02:11:37 GMT

Your export Excel is a table box or straight table? If it is a straight table, are you may be suppressing negative values from the dimension or Dimension Limits tab?

Re: Manual Calculation versus Expression Calculation Not Matching

pnn44794 — Wed, 11 Apr 2018 04:11:10 GMT

Straight table. I am not suppressing any values or at least not deliberately.

Re: Manual Calculation versus Expression Calculation Not Matching

sunny_talwar — Wed, 11 Apr 2018 09:22:14 GMT

To tell you the truth, I am not sure what might be going

Re: Manual Calculation versus Expression Calculation Not Matching

pnn44794 — Wed, 11 Apr 2018 16:53:54 GMT

Thanks Sunny. I appreciate you taking a look. Sorry for the delay in getting back to you too. Turns out, I had a problem with my data model and I was getting extra rows of data which caused the mismatch in the manual versus expression calculation. It's fixed now.

Thanks again.