Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi Maurice, please take a look at this document: QlikCommunity Tip: How to get answers to your post?
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
Hi Jonathan,
Here is my example
Thank you
Hi Maurice, I exported the table to Excel and I don't see any gap, can you give more details about the issue?
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
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.
if you selects the year 2015 and the months of December and you extract you'll notice the differnece
how I can use it later in the expression?