How to upload excel.xls file into qlickview?

[ravireddyk]

How can i upload excel file into qlickview?

i have excel files like

1) Employee.xls

2)Sales.xls

help me out for this..

[maxgro]

ctrl+e for script editor

at the bottom choose Data tab

click Table Files button

choose the excel file (xls or xlsx)

follow the File Wizard

[Anonymous]

Hi

On the edit scrip  to select

and choose the path where is it.

or

LOAD *

FROM

(ooxml, no labels, table is Sales);

and  reload

i hope  help you

Regards

[Anonymous]

Hi,

Click on Edit Script or Ctrl E 😆 Under Bottom Data Tab 😆 Click on Table files 😆 Select the excel file 😆 Make necessary changes 😆 Save the file.

Hope it helps!!

[Anonymous]

Hi,

You can follow the steps in mentioned link:

QlikView – Connecting to excel file | Learn QlikView

[ravireddyk]

in excel sheet i dont have fields like country but i did't have country in selection feild ...how to solve

[Anonymous]

Hi,

I didn't understand could you please elaborate your requirement.

[ravireddyk]

i have excel file of employee and sales xls already imported but i want to create a dashboard,but i need country field in any chart but i am not able to get country feild .

[ravireddyk]

i have imported excel sheets but i am not having country feild in both excel sheets,but i need to consider country feild in qlickview....how it will be solved

[Anonymous]

Add country field details  in Excel sheet, save and upload once again