Less number of rows after exporting to excel

[#1]

Hi,

I am getting less number of rows in table box in Qlikview however the count of rows in table is showing correct in Qlikview Data model

[swuehl]

A table box only shows distinct combination of column values, not duplicate rows.

[#3]

it is happening in Straight Table as well

[swuehl]

Could you post some more details what you exactely you are comparing in QV vs. Excel?

[shawn-qv]

QV will only display distinct records in the table objects (including in Pivot and Straight tables).

If you want to be sure, you may include a "counter" field into your load, such as RecNo() or RowNo(). This will ensure that you have a unique record-level field to display in your Tablebox.

S.