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

Can Qlikview work with one excel sheet as datasource?

Fri, 07 Jun 2013 15:26:24 GMT

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?

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

jagan — Fri, 07 Jun 2013 15:42:06 GMT

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.

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

Fri, 07 Jun 2013 15:59:12 GMT

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

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

Fri, 07 Jun 2013 21:21:34 GMT

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

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

Sokkorn — Sat, 08 Jun 2013 03:45:53 GMT

Hi,

Check this video

Regards,

Sokkorn

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

jagan — Sat, 08 Jun 2013 08:31:31 GMT

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.