excel source problem

Wed, 21 Mar 2012 02:00:14 GMT

hi,

i have a problem with regards to my source. how can i load this so that i will only have a moth field instead of jan, feb mar etc..

see attached file

Re: excel source problem

Wed, 21 Mar 2012 03:50:01 GMT

Hi,

You need to do a cross table. Use script below

Forums:

CrossTable(Month, Val, 5)
LOAD Field1,
Field2,
Field3,
Year,
Field4,
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12
FROM
C:\Downloads\forums.xlsx
(ooxml, embedded labels, table is Sheet1);

topic Re: excel source problem in QlikView

excel source problem

Re: excel source problem