Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ravireddyk
New Contributor III

imported excel file..!

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

Tags (1)
5 Replies

Re: imported excel file..!

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

Great dreamer's dreams never fulfilled, they are always transcended.
alibd225
Contributor

Re: imported excel file..!

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
Honored Contributor II

Re: imported excel file..!

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

......

MVP
MVP

Re: imported excel file..!

- 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

neetha_p
Honored Contributor

Re: imported excel file..!

hi,

please attach excel files