Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
deepti_singh
Creator II
Creator II

Incorrect number of rows when exporting a chart to excel

Hi,

     I am trying to export a straight table to excel. When in QlikView, the number of rows is 4,661 rows but when I export it to an excel sheet the number of rows decrease to 4,006. I am not sure why this inconsistency?

Thanks.

Regards,

Deepti Singh

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

deepti,

I'm pretty sure that QlikView is taking rows that are duplicates and displaying them once in your chart. This is normal QV behavior. If you have a field that is a uniqu identifier for each record (RowNo() as LineNo in script), and you include that field in the chart, the duplicate records will all be displayed.

View solution in original post

16 Replies
Anonymous
Not applicable

Can you upload you application?

Is it the native "send to excel", or maybe you're using a macro?

m_woolf
Master II
Master II

Can you post an example qvw showing this behavior?

deepti_singh
Creator II
Creator II
Author

Sure.

But can anyone tell me how to mask the data? The information is sensitive.

I tired the scramble option in the Document properties but it didn't help.

m_woolf
Master II
Master II

How do you know the number of rows in the table in QlikView?

oknotsen
Master III
Master III

You could do an "autonumber()" over all the field your are loading for this demo and multiply facts your are loading with a "rand()".

May you live in interesting times!
deepti_singh
Creator II
Creator II
Author

Mike,

     I have the count function in the Title, it goes like this

num(count($(=estrTradeRanges) DISTINCT ID), '#,##0') & ' rows'

Thanks.

Regards,

Deepti Singh

deepti_singh
Creator II
Creator II
Author

Michael,

     It is a native "send to excel" command.

ramoncova06
Partner - Specialist III
Partner - Specialist III

using an expression is not the same as the total number of rows, whenever you click on the table you get what are the total of rows in the bottom right hand, check how many rows your table actually has, also you might to check for items that have more than one in you expression

2.png

deepti_singh
Creator II
Creator II
Author

Ramon,

I cant see that at the bottom of the QlikView file. Do I need to change any settings?