Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to load a pivot table to Qlikview

Hi,

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?

Company14 November 2012 15 November 201216 November 201217 November 201218 November 201219 November 201220  November 201221 November 2012
Company 112207213
Company 202114314
Company 320105402
Company 401022041
Company 513101411
Company 604252110
Company 721323100
Company 810114021
Company 910214013
Company 1011022021







































































2
3
4
5
Company 2101230
Company 3123450
Company 4123456
Company 5123450
Company 6001230
Company 7123450
Company 8012345
Company 9123000

























































































Company
  Name
14 Nov 1215 Nov 1216 Nov 1217 Nov 1218 Nov 1219 Nov 12
Company 1012345
Company 2101230
Company 3123450
Company 4123456
Company 5123450
Company 6001230
Company 7123450
Company 8012345
Company 9123000
4 Replies
Gysbert_Wassenaar

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.

[Data]:

CrossTable(Date, Amount, 1)

LOAD *

FROM

[crosstabtest.xls]

(biff, embedded labels, table is Sheet1$);

If you want to load the data as it is in Excel, then leave out the CrossTable line.


talk is cheap, supply exceeds demand
Not applicable
Author

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?

Gysbert_Wassenaar

use the Date function: Date(MyDate, 'DD MMMM YYYY')


talk is cheap, supply exceeds demand
Not applicable
Author

This is my script,

where do i use the Date function:

SET

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);