Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jagan
Luminary Alumni
Luminary Alumni

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
Author

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

Not applicable
Author

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
Master
Master

Hi,

Check this video

Regards,

Sokkorn

jagan
Luminary Alumni
Luminary Alumni

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.