topic Re: missing records export excel in QlikView

missing records export excel

Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: missing records export excel

marcus_sommer — Wed, 08 Mar 2017 12:51:01 GMT

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

Re: missing records export excel

Wed, 08 Mar 2017 13:07:00 GMT

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

if not, how do i do it ?

Re: missing records export excel

ramasaisaksoft — Wed, 08 Mar 2017 13:32:30 GMT

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"

Re: missing records export excel

marcus_sommer — Wed, 08 Mar 2017 19:23:58 GMT

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

- Marcus

Re: missing records export excel

nancypoliti — Wed, 08 Mar 2017 19:54:27 GMT

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