Qlikview File Loading

[#1]

When I upload the excel file, Qlikview converts the columns as showing above. I need to remove "Sheer1$" from each column so that I can join it with other table containing Cust Country column. How do I do this? Please help

[marcus_sommer · Accepted solution]

This happens because there is somewhere a qualify statement within your script - use simply unqualify or remove the other statement.

Qualify *;

Unqualify *;

- Marcus

[#3]

Cool, it works. Thank you Marcus