Send to Excel issue

[#1]

Hi,

I am trying to export a table into excel but somehow few records are missing.

Suppose there are 5000 records, 4950 records are getting exported. I verified this issue by counting records and taking sum of numeric field also. I am using QV 10 and office 2010.

Please suggest.

Mayank

[Miguel_Angel_Baeyens]

Hi Mayank,

Is that a straight or pivot table? If so, did you try exporting a table box instead? Note that in a chart like the pivot table, some dimension values may not have their corresponding aggregated values (i. e.: sum for the selectin made is equal to zero or null), so they don't appear in the chart, and they are not exported.

Assuming that you are not doing any WHERE clause in your load script, amd that all values are being loaded into QlikView, Check as well that you are not using the "Suppress when value is null" tick in your chart properties, Dimensions tab.

Hope that helps.

Miguel

[#3]

Hi Miguel,

Thanks for responding.

I am just using Table Box with no charts.

I sum hours field using Sum(Hours) and it summed up to 5286.6. When I sent it to excel, sum in excel shows 5284.6!!

Mayank

[vijay_iitkgp]

Hi Mayank,

How do you use Sum(Hours) in Table box ???

[#5]

I didn’t sum(Hours) in Tablebox. I used Text field to get the sum.

Mayank

[vijay_iitkgp · Accepted solution]

Then There must be some duplicating rows in your table . By default qlikview use distinct rows in tablebox. you can create rowNo() as one extra field and use it in table box. Hope this will solve your problem.

Regards

VIjay

[Miguel_Angel_Baeyens]

Hi Mayank,

That difference may be caused by rounding the decimal positions in both QlikView and Excel. If amounts, quantities and lines show the same, the should sum the same.

Is that possible?

Miguel

[#8]

You hit the nail buddy. Thanks a lot!

[#9]

Okay. But how can I hide RowNo() so that it shouldn’t be displayed in the table though it should work as it is? Right now, my table contains RowNo as a field which looks irrelevant.

Mayank

[vijay_iitkgp]

You can use Straight Table instead of Table box with expression 1 and hide the rowno and expression.

Regards

Vijay