topic Re: CrossTable Data Issue in QlikView

CrossTable Data Issue

mphekin12 — Mon, 31 Mar 2014 14:04:33 GMT

I have a strange issues I'm hoping someone can help me out with. I have an Excel file with Budget information on it. I'm using a CrossTable function to bring the data into my QlikView application. I have three columns: MonthYear, CostBudget and Warehouse. The Warehouse field is a text field, although there are some numeric values. A few examples are GFCA, 001, 730, 730M, and 6501.D. The issue that I am having is that the warehouses have mixed alphanumeric values (like 730M and 6501.D) are not being loaded.

Has anyone experienced this issue? Any suggestion to fix this issue?

I appreciate your help!

Re: CrossTable Data Issue

Gysbert_Wassenaar — Mon, 31 Mar 2014 14:27:39 GMT

Can you post a sample excel file that gives the result you describe?

Re: CrossTable Data Issue

mphekin12 — Mon, 31 Mar 2014 14:42:06 GMT

Gysbert,

Thanks for your reply.

Unfortunately I can't post the excel file. If the values for the warehouses are blank on the spreadsheet, will they not be brought in?

Thank you!

Re: CrossTable Data Issue

giakoum — Mon, 31 Mar 2014 14:55:00 GMT

try reading the warehouse value as text using the text function

Re: CrossTable Data Issue

mphekin12 — Mon, 31 Mar 2014 15:44:35 GMT

I have tried that Ioannis. Thanks for your reply.