Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi Mayank,
How do you use Sum(Hours) in Table box ???
I didn’t sum(Hours) in Tablebox. I used Text field to get the sum.
Mayank
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
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
You hit the nail buddy. Thanks a lot!
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
You can use Straight Table instead of Table box with expression 1 and hide the rowno and expression.
Regards
Vijay