Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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