How to check the records?

[Nagaraju_KCS]

Hi All,

Suppose i have Category field in my Database.

each category have some records. when i am clikck the category it displays some records.

how to check the data correct or not

Thanks....

[marcus_sommer]

Check qv-data with source-data, it s not the same and the reason is not simply to find per load-log and debugger then create additionally table-copies - and add rowno() - per qualify command and put this table in GUI in a tablebox and check again with source-data.

- Marcus

[kaushiknsolanki]

Hi,

     Other way is you count the numbers of records which qlikview has loaded for that table.

     For that you can go to Settings -> Document Properties -> Table

     Here you will find the list of tables and their count.

Regards,

Kaushik Solanki

[#4]

1. Check with the source data

2. Count the number of item in qlikview and Source.

Select the one category in qlikview

and In textbox give a below expression count(Yourfield)

and check with the source

Select Count(Yourfield) as Countofuefield from urtable category='Wat is ur selection?';

check this two number, if these are same then ur appliation is correct.