Unable to Do the Cross table in Qlikview for the Excel data

[Chaitanya_Vinnakota]

Hi all

I have an issue with the Cross table. When I was trying to do the cross table to get the year and population column into the front end from the excel, I was unable to get the value for the population column and it remains to show the Year in the Population column.

I have done the cross table as follows

CrossTable(Year, Population, 4)
LOAD [Country Name],
[Country Code],
[Indicator Name],
[Indicator Code],
1960,
1961,
1962,
1963,
1964,
1965,
1966,
1967 and so on....

After doing the cross table, till [Indicator Code], It showed me as a column with red color, and the remaining part was showing me in black and in the front end, the Population column didn't get the corresponding values.

I forwarded the same excel(data) to one my friend and he can able to do the cross table within a minute and sent back to me.  Even I uninstall the software and tried again but there is no luck from my end.  At last, I tried to enable the  Load * option in file wizard of Cross table for that excel then the value of the population came.  

Please let me know what might be the reason it was not coming correctly to me and by the way, I am using the Qlikview Version 11.0.11282.0

I am also attaching the excel file and the screenshots which I tried.

Thanks & Regards

Chaitanya Vinnakota

[Saravanan_Desingh · Accepted solution]

CrossTable(Year, Population, 4)
LOAD [Country Name],
[Country Code],
[Indicator Name],
[Indicator Code],
[1960],
[1961],
[1962],
[1963],

I think the Year Fields are not closed with square brackets. 

[Chaitanya_Vinnakota]

Hi Saran,

I have done through wizard not done  manually and the same excel was forwarded to my friend and he was able to do it and by the way, I tried to store the data into QVD from this excel. Data was converting fine but when I call the QVD, the problem remains the same.

Thanks & Regards

Chaitanya Vinnakota

[martinpohl · Accepted solution]

as I remember, there was a problem with QlikView 11 and columns with leading numbers in field name, so set it to

[1961]

or 

"1961"

and so on although the assistant is using 1961

Regards

why don't update?