topic Re: Problem exporting to excel in QlikView

Problem exporting to excel

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a problem which I cannot understand. I am extracting data from qlikview to excel and using the same data/filters I get excel files with a different number of rows everytime. This happens for the exact same information.

Is this a frequent issue or has happened to anyone else?

Thank you

Re: Problem exporting to excel

sudeepkm — Thu, 29 Dec 2016 16:18:41 GMT

As long as the filter selection and volume of data in your app remains same the excel export should contain the same result. Could you check data refresh schedule?

Re: Problem exporting to excel

Thu, 29 Dec 2016 17:24:01 GMT

Hi,

Can you post the qvw? This would make it easier for us to help you out.

Thanks!

Stan

Re: Problem exporting to excel

pipuindia99 — Fri, 30 Dec 2016 11:00:24 GMT

Hi,

Can you post your qvw?, it should probably give me a better idea

Re: Problem exporting to excel

Fri, 30 Dec 2016 11:07:10 GMT

Hello,

Looks like the issue is now solved since it it no longer happening. Still don't know what may have caused this maybe a timeout during the extracting process.

Thank you Stan and Prabhu for your availability.

Re: Problem exporting to excel

sathishkumar_go — Fri, 30 Dec 2016 11:20:04 GMT

Hi,

Are you exporting to excel by macro?

otherwise please attach the application here.

-Sathish

Re: Problem exporting to excel

quwok — Fri, 30 Dec 2016 12:43:04 GMT

You did not provide much detail for us to work with, how are you comparing the data? The exported data against QlikView or the source data? When you say you get different results with the same filter, is it the same filter in QlikView showing different result each time or are you referring to the equivalent filters in Excel?

Anyway, taking the assumption that you are comparing the exported data against the source, and additionally assuming that by extracting you mean exporting the data from a tabular object in QlikView to Excel, the difference could be because QlikView dedupes the data in lists and tables. This means that rather than the expected 10 records, QlikView is only showing the 9 unique rows, similarly the export will only have the 9 unique records.

Re: Problem exporting to excel

alis2063 — Sat, 31 Dec 2016 16:59:52 GMT

Hi Ines,

Its was same happened with me later on i had realized that the qlik View document selection was different than before.