Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
im using SQL so i dont think i have the recno() or rowno() option
if not, how do i do it ?
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"
You could implement recno() and othe qlik-functions within a Preceding Load.
- Marcus
A table box doesn't have expressions. You're thinking of a straight table chart.