Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 Branch | Sales | Year |
Barking | 20,000 | 2015-16 |
Ilford | 30,000 | 2015-16 |
Gants Hill | 50,000 | 2015-16 |
Deghanam | 60,000 | 2015-16 |
Greenwich | 70,000 | 2015-16 |
East ham | 90,000 | 2015-16 |
Canning town | 100,000 | 2015-16 |
Total | 420,000 |
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.