Qlikview not importing all records from excel

[#1]

I am trying to import into excel all records from excel file;  How I can import all records into qlikview; please advise;

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='£#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

LOAD Account,

          Date,

          Credit

FROM (biff, embedded labels, table is [Transaction Detail by Account$]);

The result is as follows:

Books	2000.00	17/05/2012
Books	2750.00	31/05/2012
Books	2800.00	24/05/2012
Books	2800.00	25/05/2012
Books	2800.00	31/05/2012
Books	2850.00	23/05/2012
Books	2850.00	29/05/2012
Books	2850.00	30/05/2012
Books	2850.00	31/05/2012
Books	2950.00	28/05/2012
Books	2950.00	30/05/2012
Books	2950.00	31/05/2012
Books	3000.00	23/05/2012
Books	3000.00	25/05/2012
Books	3050.00	31/05/2012
Books	3800.00	30/05/2012
Books	3870.00	25/05/2012

Please find attached excel file;

qlikview version 8.5 excel file: office 2010

[alexandros17]

Data are all loaded but equal rows are excluded in tables ... to verify create a graph with date and account as dimensions and sum(credit) as expression; you will see that totals are correct and equal to excel

[hic · Accepted solution]

When I load your Excel file, I can see that you have 41 records in it, and that is also what QlikView has loaded.

But in a table box, QlikView will just display the 28 unique records, i.e. it will not show duplicates. But when you use the data in calculations (pivot table, bar chart, etc.), the calculation will be made on all 41 records.

If you create a field

     RecNo() as RecordID

you will clearly see all records.

HIC