Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem exporting to excel

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

7 Replies
sudeepkm
Specialist III
Specialist III

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?

Not applicable
Author

Hi,

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

Thanks!

Stan

pipuindia99
Creator III
Creator III

Hi,

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

Not applicable
Author

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
Partner - Specialist
Partner - Specialist

Hi,

Are you exporting to excel by macro?

otherwise please attach the application here.

-Sathish

quwok
Creator III
Creator III

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
Creator III
Creator III

Hi Ines,

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