Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using Excel Files without a Table Format

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!

5 Replies
Not applicable

Hi Robyn,

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

Master II
Master II

Can you please share a sample app ?

Specialist
Specialist

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.

Not applicable

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.

Creator
Creator

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