topic Diff b/w excel and qvw in QlikView

Diff b/w excel and qvw

Wed, 01 Sep 2010 12:20:04 GMT

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

12345

Well

12345

Well

23456

Well

23456

Issue

12345

Issue

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

I believe it is suspecting duplicate records.

Thanks,

tresB — Wed, 01 Sep 2010 12:33:22 GMT

Hi Tims,

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

deepakk — Wed, 01 Sep 2010 12:59:46 GMT

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

Wed, 01 Sep 2010 13:18:39 GMT

Thanks for the quick response...

Thanks,

Wed, 01 Sep 2010 13:58:19 GMT

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.