topic Re: Use column headers from data file in QlikView

Use column headers from data file

Thu, 19 Jan 2012 17:27:45 GMT

When I try to create a qlikview document using the wizard, the option "Use column headers from data file" is dimmed, why is this happen?

I managed to resolve the problem by using the script editor instead if the Wizard. Thanks for all your responses.

Use column headers from data file

john_duffy — Thu, 19 Jan 2012 18:00:04 GMT

Hello.

Do you have data in your Excel spreadsheet? If the spreadsheet is empty, the option will be dimmed.

John.

Use column headers from data file

Thu, 19 Jan 2012 18:23:53 GMT

Hi,

Yes I do have data in the spreadsheet. I have column titles and data in the spreadsheet. I also have formulas in the spreadsheet for some columns, is this causing the problem?

Re: Use column headers from data file

Thu, 19 Jan 2012 18:24:24 GMT

Hi,

Yes I do have data in the spreadsheet. I have column titles and data in the spreadsheet. I also have formulas in the spreadsheet for some columns, is this causing the problem?

Re: Use column headers from data file

john_duffy — Thu, 19 Jan 2012 18:36:43 GMT

Hi.

I created a simple spreadsheet with formulas and was able to load it okay with the Column Headers option. Can you attach the spreadsheet?

John.

Re: Use column headers from data file

Thu, 19 Jan 2012 18:51:25 GMT

Hi,

I managed to get round the problem by copying the data from the spreadsheet into a new workbook. Seems to work now, but not sure what the problem was.

Re: Use column headers from data file

Thu, 19 Jan 2012 19:02:59 GMT

More problems.Now I get the message "Execution of script failed. Reload Data?" when Qlikview tries to load the spreadsheet. When I click "Yes" Qlikview just crashes on me. Can you please help - thanks

Use column headers from data file

Anonymous — Fri, 20 Jan 2012 07:27:00 GMT

Your error can mean anything.

It just says the script failed.

Without the script and an example of your excel file it will be hard to help you.

Can you share them with us?

Re: Use column headers from data file

Wed, 14 Mar 2012 15:17:42 GMT

Thanks everyone for your help and comments. I managed to resolve my teething issues and I am up and running with my Qlikview Dashboards.

Kind Regards