Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello. I am new to qlikview. I am extracting a report by filtering the dimensions and export to excel. However the drill through results does not pick all the filtered rows.
1. Is the a way to view a number of rows in qlikview before you export the rows to excel?
2. What could be causing this, besides the logic in drill through report and Analysis ?
Thanks Elly
Most Likely the number of rows in Excel are being exceded - to get the number of rows, you could do a simple set analysis and apply the same conditions you are using for filtering .
Elly, to the other poster's comment, have you checked that you do not have another sheet in Excel with the rest of the data there? I believe things should wrap from what I recall, so check that to be sure that is not what is happening. Just an FYI, if the export is more rows than Excel will handle, we change the file to .csv in those cases instead of .xls or .xlsx.
In order to provide anything further, would really need a sample application/QVW with the issue, so I could play around with things myself to try to figure out what is going on for you.
Regards,
Brett