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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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