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

How to upload excel.xls file into qlickview?

ravireddyk — Fri, 04 Sep 2015 22:00:10 GMT

How can i upload excel file into qlickview?

i have excel files like

1) Employee.xls

2)Sales.xls

help me out for this..

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

maxgro — Fri, 04 Sep 2015 22:07:22 GMT

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

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

Anonymous — Fri, 04 Sep 2015 22:12:15 GMT

On the edit scrip to select

and choose the path where is it.

LOAD *

FROM

(ooxml, no labels, table is Sales);

and reload

i hope help you

Regards

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

Anonymous — Sat, 05 Sep 2015 02:39:01 GMT

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

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

Anonymous — Sat, 05 Sep 2015 02:44:15 GMT

Hi,

You can follow the steps in mentioned link:

QlikView – Connecting to excel file | Learn QlikView

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

ravireddyk — Sat, 05 Sep 2015 04:01:44 GMT

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

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

Anonymous — Sat, 05 Sep 2015 04:12:07 GMT

Hi,

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

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

ravireddyk — Sat, 05 Sep 2015 04:30:05 GMT

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 .

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

ravireddyk — Sat, 05 Sep 2015 04:56:13 GMT

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

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

Anonymous — Sat, 05 Sep 2015 05:52:08 GMT

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

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

ecolomer — Sat, 05 Sep 2015 09:14:09 GMT

You can see this video:

Importing Data from Excel into Qlik (QlikView) - YouTube

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

ecolomer — Sat, 05 Sep 2015 09:14:53 GMT

and this

New to QlikView: Load Data from Excel - YouTube

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

Anonymous — Sat, 05 Sep 2015 11:42:21 GMT

hi ravinder,

Please see:

Loading Excel Data into QlikView