Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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:
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
......
- 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
hi,
please attach excel files