topic Re: gap between QlikView and Excel in QlikView

gap between QlikView and Excel

MauriceLudo — Wed, 25 Nov 2020 16:16:04 GMT

Hello,
I have a gap in total between QlikView and excel when I export my table to excel , could you tell me where can come mistake thank you.

Re: gap between QlikView and Excel

jonathandienst — Tue, 03 May 2016 09:49:02 GMT

Hard to say based on the absence of detail in your question. I suggest that you are more specific about what is lacking and post samples, including a qvw file illustrating the problem.

Re: gap between QlikView and Excel

rubenmarin — Tue, 03 May 2016 10:01:43 GMT

Hi Maurice, please take a look at this document: QlikCommunity Tip: How to get answers to your post?

Re: gap between QlikView and Excel

marcus_sommer — Tue, 03 May 2016 10:23:02 GMT

If you used a tablebox for this comparing you will only get the distinct values of the included fields. In this case you need to add a unique row-identifier to this tablebox and if there are no one exists you could create one in the script with:

rowno() as RowNo

- Marcus

Re: gap between QlikView and Excel

MauriceLudo — Tue, 03 May 2016 10:39:13 GMT

Hi Jonathan,

Here is my example

Thank you

Re: gap between QlikView and Excel

rubenmarin — Tue, 03 May 2016 10:50:15 GMT

Hi Maurice, I exported the table to Excel and I don't see any gap, can you give more details about the issue?

Re: gap between QlikView and Excel

MauriceLudo — Tue, 03 May 2016 12:44:27 GMT

Marin

if you make the sum of the column Actuals N YTD SMART , you'll notice the difference

in qlikview : -155,22076

in excel :-157.46

Re: gap between QlikView and Excel

rubenmarin — Tue, 03 May 2016 12:54:38 GMT

Hi Maurice, sorry but I didn't notice any difference, if you check my Excel above it also exports -155,22.

The difference you said coincides with the 'RU' G9178, check the answer given by Marcus below, maybe there are two equal rows, and in a table box it will show only one row.

Re: gap between QlikView and Excel

MauriceLudo — Tue, 03 May 2016 13:52:39 GMT

if you selects the year 2015 and the months of December and you extract you'll notice the differnece

Re: gap between QlikView and Excel

MauriceLudo — Tue, 03 May 2016 16:06:39 GMT

how I can use it later in the expression?