Can Qlikview work with one excel sheet as datasource?

[#1]

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?

[jagan]

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.

[#3]

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

[#4]

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]

Hi,

Check this video

Regards,

Sokkorn

[jagan]

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.