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

[prieper]

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

[sunny_talwar]

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

[Anil_Babu_Samineni]

May be check

LET VariableName = NoOfRows('FieldName');

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

[manoranjan_d]

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

[manoranjan_d]

its showing hypen for seeing in the variable

[manoranjan_d]

@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

[manoranjan_d]

sunny can u reply me

[sunny_talwar]

Do you have section access?

[balabhaskarqlik]

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