Diff b/w excel and qvw

[#1]

Hi,

I have created one Table box in Qlikview using excel sheet , I am seeing difference between excel records and dash board records.

May I know is there any settings in the properties to see the duplicate records.

Sr No	Customer ID	well / Issue
1	12345	Well
1	12345	Well
3	23456	Well
4	23456	Issue
5	12345	Issue

In Dashboard the first 2 records are showing in single record.

I believe it is suspecting duplicate records.

Thanks,

[tresesco]

Hi Tims,

What you are suspecting is correct. In table only the distinct combinations(Record) is shown .

[deepakk]

hi ,

You can view the the number of times the record is getting repeated by enabling the frequency of a List box.

Go to the general tab of a list box and enbale the frequency button.

Deepak

[#4]

Thanks for the quick response...

Thanks,

[#5]

If you want to see the duplicate records you can add a unique key in your load - e.g. using recno function.

Note the dup records ARE in you tables, as you would see if you do any arithemtic with the data.