Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ravireddyk
New Contributor III

How to upload excel.xls file into qlickview?

How can i upload excel file into qlickview?

i have excel files like

1) Employee.xls

2)Sales.xls

help me out for this..

Tags (1)
12 Replies
MVP
MVP

Re: How to upload excel.xls file into qlickview?

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

maverjannet
Valued Contributor

Re: How to upload excel.xls file into qlickview?

Hi

On the edit scrip  to select

Captura6.JPG

and choose the path where is it.

or

LOAD *

FROM

(ooxml, no labels, table is Sales);

and  reload

i hope  help you

Regards


qlikviewnovice
Valued Contributor II

Re: How to upload excel.xls file into qlickview?

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

qlikviewnovice
Valued Contributor II

Re: How to upload excel.xls file into qlickview?

Hi,

You can follow the steps in mentioned link:

QlikView – Connecting to excel file | Learn QlikView

ravireddyk
New Contributor III

Re: How to upload excel.xls file into qlickview?

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

qlikviewnovice
Valued Contributor II

Re: How to upload excel.xls file into qlickview?

Hi,

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

ravireddyk
New Contributor III

Re: How to upload excel.xls file into qlickview?

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
New Contributor III

Re: How to upload excel.xls file into qlickview?

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

qlikviewnovice
Valued Contributor II

Re: How to upload excel.xls file into qlickview?

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