topic Re: Count Mismatch in QlikView

Count Mismatch

manoranjan_d — Thu, 01 Jun 2017 12:19:52 GMT

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

Re: Count Mismatch

prieper — Thu, 01 Jun 2017 12:22:14 GMT

Have you checked for duplicated records?

This would show only as 1 row.

Adding a COUNT(MyField) to the data should end with the correct amount of records.

Likewise you should see the same in the datamodel (Cntrl + T)

Peter

Re: Count Mismatch

sunny_talwar — Thu, 01 Jun 2017 12:23:01 GMT

Do you have where statements or Left/Right Joins/Keeps when you pull the data? or section access?

Re: Count Mismatch

Anil_Babu_Samineni — Thu, 01 Jun 2017 12:24:34 GMT

May be check

LET VariableName = NoOfRows('FieldName');

and create text box then use Variable whether tell me how many rows showing?

Re: Count Mismatch

manoranjan_d — Thu, 01 Jun 2017 12:25:11 GMT

joins i didnt use just simply retriving the single table @ sunny

Re: Count Mismatch

manoranjan_d — Thu, 01 Jun 2017 12:30:20 GMT

its showing hypen for seeing in the variable

Re: Count Mismatch

manoranjan_d — Thu, 01 Jun 2017 12:31:43 GMT

@anil its should be table name right? table name using means then i geeting the correct count

if i use any field name means its showing hypen value

Re: Count Mismatch

manoranjan_d — Thu, 01 Jun 2017 12:34:05 GMT

sunny can u reply me

Re: Count Mismatch

sunny_talwar — Thu, 01 Jun 2017 12:37:33 GMT

Do you have section access?

Re: Count Mismatch

BalaBhaskar_Qlik — Sun, 02 Sep 2018 14:05:13 GMT

Did you able to resolve the issue, post the solution.

Re: Count Mismatch

BalaBhaskar_Qlik — Sun, 02 Sep 2018 14:09:16 GMT

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.