Discussion Board for collaboration related to QlikView App Development.
I have and excel dataset that looks like the one below, and would like to load this info into Qlikview. Please help, how do i load the info?
You can use the CrossTable statement to load this data in a form that's more useful than the layout it now has in excel.
CrossTable(Date, Amount, 1)
(biff, embedded labels, table is Sheet1$);
If you want to load the data as it is in Excel, then leave out the CrossTable line.
My dates are automitically formatted to numbers ie 14 November 2012 get loaded as 41228. What can i do to ensure that the dates remain as DD Mont Year?
use the Date function: Date(MyDate, 'DD MMMM YYYY')
This is my script,
where do i use the Date function:
ThousandSep=' ';SET DecimalSep='.';SET MoneyThousandSep=' ';SET MoneyDecimalSep=',';SET MoneyFormat='R # ##0,00;R-# ##0,00';SET TimeFormat='hh:mm:ss TT';SET DateFormat='YYYY/MM/DD';SET TimestampFormat='YYYY/MM/DD hh:mm:ss[.fff] TT';SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';CrossTable(Date, Amount, 1)LOAD *FROM [..\Daily Safety Report (4).xlsx](ooxml, embedded labels);