Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel file loading?

How I load an excel table in Qlik view script editor?

Can anyone help me step by step?

Description

I had one table in Excel

   

Tesco sales by BranchSalesYear
Barking20,0002015-16
Ilford30,0002015-16
Gants Hill50,0002015-16
Deghanam60,0002015-16
Greenwich70,0002015-16
East ham90,0002015-16
Canning town 100,0002015-16
Total420,000
2 Replies
vamsee
Specialist
Specialist

vishsaggi
Champion III
Champion III

In your edit script use Tables files and open the path of that excel file and click open. It will open a File type wizard. Then select the sheet name and embedded labels as shown in the screen shot.

Capture.PNG

Capture1.PNG