topic Re: DashBoard Date Problem in QlikView

DashBoard Date Problem

pgalvezt — Thu, 21 Apr 2016 20:36:25 GMT

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!

Re: DashBoard Date Problem

jonas_rezende — Fri, 22 Apr 2016 12:32:59 GMT

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!

Re: DashBoard Date Problem

pgalvezt — Fri, 22 Apr 2016 14:56:36 GMT

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!

Re: DashBoard Date Problem

jonas_rezende — Fri, 22 Apr 2016 15:22:15 GMT

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.

Re: DashBoard Date Problem

pgalvezt — Fri, 22 Apr 2016 15:33:09 GMT

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!

Re: DashBoard Date Problem

jonas_rezende — Mon, 25 Apr 2016 12:27:38 GMT

Hi, Pablo Gálvez.

When you load individually Presupuesto table, the result of fields Horas Normales and Horas Extras ?