Actual CV count and Data loaded in Qlik Sense count Mismatch

[Sarvajit]

Hi,

My CV count is 14k (checked sql ) but when I load data in qlik sense I m getting 1 Lakh + count.

I m using SAP HANA and added some condition in Data load editor 

for eg:

SQL select Col1,

Col2,

Col3

 FROM CV_NAME"
where IFNULL("Col54",'N') <> 'Value'
and COALESCE("Col5",'N')='N'
and ("ACTIVE_FLAG"='Yes' or "Col1" in (select t1.Col6 from CV_NAME" t1));

I m using same CV in inner query also. Even after commenting last line I m getting more count compare to actual count.

[rubenmarin1]

Hi, you are using this exact same wuery in Qlik and it returns a different number of rows than in HANA? Something has to be different, maybe some kind of permissions, or the connection is to another system or the qlik script is doing something more than duplicates files.

Double check that everything is really the same and nothing more is done on Qlik.