Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Can Qlikview work with one excel sheet as datasource?

I have an excel where it has already analyzed data of all Reps ranked. My company wants it to see more in the form of gauge/charts.

I do not have any other table or source to connect to. This is like a testing data.

So is it possible to do in Qlikview desktop?

5 Replies
MVP
MVP

Re: Can Qlikview work with one excel sheet as datasource?

Hi,

It is possible to import Excel file data to qlikview, by clicking Edit Script icon (Ctrl + E), then

Click Table Files button and select the excel file, and then select your sheet in Tables dropdown and finally click Finish.

Please find attached screenshot.

Regards,

Jagan.

Not applicable

Re: Can Qlikview work with one excel sheet as datasource?

My question is can we pull all the columns in the excel and play with it?

Not applicable

Re: Can Qlikview work with one excel sheet as datasource?

Hi,

Yes in jagan mohan example play with the header size & Label drop downs and U will see the result as it will appear.

brg

//KArathorn

Sokkorn
Honored Contributor

Re: Can Qlikview work with one excel sheet as datasource?

Hi,

Check this video

Regards,

Sokkorn

MVP
MVP

Re: Can Qlikview work with one excel sheet as datasource?

Hi,

You can pull all the columns, after you select the Sheet and click OK, then the query will be pasted in the script window with all the columns, if you do not want any particular column you can remove it.

Hope this helps you.

Regards,

Jagan.

Community Browser