Incorrect number of rows when exporting a chart to excel

[deepti_singh]

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

[Anonymous]

Can you upload you application?

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

[m_woolf]

Can you post an example qvw showing this behavior?

[deepti_singh]

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]

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

[oknotsen]

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

[deepti_singh]

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]

Michael,

     It is a native "send to excel" command.

[ramoncova06]

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

[deepti_singh]

Ramon,

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