Discussion Board for collaboration related to QlikView App Development.
I have an excel file with this kind of format:
column 1 ... 12 are the month columns, when I try to use the cross table function in qlikview it gives me the wrong amount per month.
Go to Solution.
I already solved the problem,
my original load statement is
From Excel Source;
i enclosed the month columns in square brackets [ ] ..
 as Jan,
 as Feb,
 as Mar,
 as Apr,
 as May,
 as Jun,
 as Jul,
 as Aug,
 as Sep,
 as Oct,
 as Nov,
 as Dec
Now my question, what is the use of the square brackets??
The field name could be in any format.
For instance, it can contain spaces, symbols such as slash, comma, etc..,
In your case, the field or column names are numbers.
It purely depends on the names defined in the sources.
To make it available to qlikview, i.e., to make such exceptional fields as a column, you need to include square brackets or double quotes at the start and end of the formatted column name.
In SQL, it is suggested to use double quotes to such column names.
Hope this helps.