Count Mismatch

[manoranjan_d]

Hi all,

Backed sql table has been retrieved to qlikview

sql backend table have 312220 record count of distinct

in the qlikview while runing the same record count of 312220 lines feteched

after viewing the data(pulling all the fields to the table) in the table box the count shows less of 305990,

why count is getting mismtached

pls help

[balabhaskarqlik]

Try with this:

LOAD *,    

         RecNo() as RecID

FROM YourTableSource;

Check these RecID's in sql, may be data is not loading because of some special characters.