Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
A table box only shows distinct combination of column values, not duplicate rows.
it is happening in Straight Table as well
Could you post some more details what you exactely you are comparing in QV vs. Excel?
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.