Discussion board where members can get started with QlikView.
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
Do you have reference from where you are taking Country Field...
If not add Country field in either Employee Excel or Sales Excel .
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
You can write a value for the country in each excel, some similar that:
'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
- add a country field to employees excel
- after you load the excel files in QlikView add an inline table to your script
load * inline [
replace EmployeeId with the name of the field you already loaded from Excel
and match the EmployeeId values with the values in Excel
please attach excel files