Problem exporting to excel

[#1]

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

[sudeepkm]

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?

[#3]

Hi,

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

Thanks!

Stan

[pipuindia99]

Hi,

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

[#5]

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.

[sathishkumar_go]

Hi,

Are you exporting to excel by macro?

otherwise please attach the application here.

-Sathish

[quwok]

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.

[alis2063]

Hi Ines,

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