missing records export excel

[#1]

Hello,

i have a total count of records in a table box on my QlikView of 4121 records, but when i export to excel, i find total count of 4090

i think this is because of removing duplicate records, however i cant find a way to turn that off

any suggestions about how to avoid removing duplicate ?

and no i don't have a primary or unique column so i cant make one.

Thank you,

KT

[marcus_sommer]

You could with recno() or rowno() within the load of these data create an unique record-id and if you put this record-id within your tablebox you will get all records.

- Marcus

[#3]

im using SQL so i dont think i have the recno() or rowno() option

if not, how do i do it ?

[ramasaisaksoft]

Hi,

Just add 1 more expression in your table box

Add-->in expression just mention like this  =1

so that all of your records got 1 (4121) so all the records will export.

if you feel you got the solution for the issue,please close the thread by clicking "Correct Answer"

[marcus_sommer]

You could implement recno() and othe qlik-functions within a Preceding Load.

- Marcus

[nancypoliti]

A table box doesn't have expressions. You're thinking of a straight table chart.