Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can I Join 3 differents dates (From Three different Tables).
I Put I comment in the first sheet. And I attached my excel Calendar. I have to show those values of excel in my Dashboard...
Thanks!
Hi, Pablo Gálvez.
You can choose the date field and use as key, the same name for the Qlikview associate. It is important to check if other fields are needed to form the key.
Try:
//tab Remuneraciones (Gestión) in line 155.
NoConcatenate
tmp_Remuneraciones:
Load
Año,
Cargo,
CeCo,
Cod. CeCo,
Domingo,
Ds.Mov.,
Ds.Trab.,
Fecha Inicio,
Fecha Inicio1,
Fecha Termino,
Fecha Termino1,
Horas Pactadas,
Hrs.Ext.,
Hrs.Ord.,
Jueves,
Trim(LlaveCalendario) as %LlaveCalendario,
Lunes,
Martes,
Mes,
Miercoles,
N° Semanas,
Nombre,
Nomina,
Rut,
Sabado,
Semana,
Sueldo,
TipoContrato,
Viernes
Resident Remuneraciones;
Drop table Remuneraciones;
RENAME Table tmp_Remuneraciones to Remuneraciones;
//tab Ppto
Presupuesto:
LOAD Año as Año_ppto,
Trim((Año&_&Month(Mes)) as %LlaveCalendario,
[Tipo Contrato] as [Tipo Contrato ppto],
If(Indicador= 'Cantidad HE', Valor, 0) as CantidadHE,
If(Indicador= 'Cantidad HH', Valor, 0) as CantidadHH,
If(Indicador= 'Valor HH', Valor, 0) as ValorHH,
If(Indicador= 'Valor HE', Valor, 0) as ValorHE,
If(Indicador= 'Dotación total', Valor, 0) as DotacionTotal,
Valor as Valor_ppto,
SemanaAño as SemanaAño_ppto,
Month(Mes) as Mesppto,
[Sem Mes] as [Sem Mes ppto],
Ceco as Ceco_ppto,
[Desc. Ceco] as [Desc. Ceco ppto]
FROM
(ooxml, embedded labels, table is Hoja1);
STORE Presupuesto into $(RepositorioQvd)Presupuesto.qvd;
P.S.: Do no let of see the example about Budget and Sales Understanding Join and Concatenate | Qlikview Cookbook.
Hope this helps!
Hi, Jonas,
Thank you for you reply but...
Doesn't work... I put your script in my app... The oher thing I need to show the other calendar pls read the comments into the first sheet...
Thanks!
Pablo Gálvez.
I saw that association was done. Could you check if your business rule is complete? Like I say in post above "It is important to check if other fields are needed to form the key."
Share with us the result that you want to reach. Please, exemplify, and facilitates the understanding of all.
Regards,
Jonas Melo.
I associated all %Keys in the tables. All totals are good... Just have to fix field "Semana" Al numbers show the same value. Look at the example pls.
Thanks!
Hi, Pablo Gálvez.
When you load individually Presupuesto table, the result of fields Horas Normales and Horas Extras ?