topic Using Excel Files without a Table Format in QlikView

Using Excel Files without a Table Format

Thu, 14 Apr 2016 20:52:04 GMT

I am trying to pull data from an excel file into my Qlik report. Its a beast of an excel file and the owner does not want to format the dataset as a table. Its been set up with filters only. Is there any way to use this data without formatting it into a table first?

Thank you in advance for any help!

Re: Using Excel Files without a Table Format

Thu, 14 Apr 2016 22:07:43 GMT

Hi Robyn,

What are you exactly trying to accomplish here? Please elaborate.

Re: Using Excel Files without a Table Format

trdandamudi — Fri, 15 Apr 2016 00:46:12 GMT

Can you please share a sample app ?

Re: Using Excel Files without a Table Format

jolivares — Fri, 15 Apr 2016 02:43:39 GMT

I think you need to use the wizard to import this kind of excel file, after you choose your file in the next step you have to make the transformation step.

I hope you got it.

Re: Using Excel Files without a Table Format

Fri, 15 Apr 2016 03:16:11 GMT

Hi Robyn,

File wizard is useful for this scenario. You can transform the data as you wish in File wizard:transform step. Filters are applied automatically.

I think its useful.

Re: Using Excel Files without a Table Format

joydipp1988 — Fri, 15 Apr 2016 06:11:04 GMT

Hii Robyn,

Its a gap between what you have (the input data) and what you want to get (output data). So it will be better if you update the excel a bit i.e. a bit more realistic and mainly put the output you want in the next sheet. This way it will be easy enough to understand your problem. Hope you understand.

Regards,

Joy