imported excel file..!

[ravireddyk]

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

[PrashantSangle]

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

[alibd225]

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

[ecolomer]

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

......

[maxgro]

- add a country field to employees excel

or

- 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

[Anonymous]

hi,

please attach excel files