topic Re: imported excel file..! in QlikView

imported excel file..!

ravireddyk — Sat, 05 Sep 2015 05:34:01 GMT

i imported the excel file of

employee and Sales into qlickview

But i dont have country feild those tables but i need to develop a dashboard on country how can i develope without the feild of country in which i imported into qlick view

Re: imported excel file..!

PrashantSangle — Sat, 05 Sep 2015 05:41:49 GMT

Hi,

Do you have reference from where you are taking Country Field...

If not add Country field in either Employee Excel or Sales Excel .

Regards

Re: imported excel file..!

alibd225 — Sat, 05 Sep 2015 05:50:59 GMT

You need to add country information in employee sheet or sales sheet.. otherwise you need to add a inline table and set country name linked with employee or sales informaiton

Re: imported excel file..!

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

You can write a value for the country in each excel, some similar that:

Res:

LOAD

'abou-dhabi' as Pais_f,

2014 as GP_Año,

Pos as GP_Posición,

N° as GP_Num,

Piloto as GP_Piloto,

Chasis as GP_Equipo,

Motor as GP_Motor,

Vuelta as GP_Vueltas,

F7 as GP_Tiempo,

Pts as GP_Puntos

FROM

......

Re: imported excel file..!

maxgro — Sat, 05 Sep 2015 08:59:00 GMT

- add a country field to employees excel

- after you load the excel files in QlikView add an inline table to your script

load * inline [

EmployeeId, Country

1, India

2, India

3, ....

....

];

replace EmployeeId with the name of the field you already loaded from Excel

and match the EmployeeId values with the values in Excel

Re: imported excel file..!

Anonymous — Sat, 05 Sep 2015 10:14:16 GMT

hi,

please attach excel files