topic Re: Join tables in QlikView

Join tables

juan_patrick — Tue, 09 Sep 2014 19:20:57 GMT

Hi! I put the problem in the attached file, and in it its what I need:

There is a table that have events, thats events has owner but only I can see it when the event is "TRANSFERIR"

In the excel its clearly; thank you!!

Re: Join tables

Marcio_Campestrini — Tue, 09 Sep 2014 19:24:36 GMT

Hi Juan

Read this:

How to populate a sparsely populated field

Márcio

Re: Join tables

juan_patrick — Tue, 09 Sep 2014 19:44:03 GMT

Márcio, the problem is tha i dont have the first and last value for each ticket!

Re: Join tables

anbu1984 — Wed, 10 Sep 2014 06:19:28 GMT

Try this

Initial:

Load ticket,actividad,fechainicio,fechafin,

If( IsNull(grupodesde) Or grupodesde = '',If(Previous(grupohasta) = '',Peek(grupoactual),Previous(grupohasta)),

grupodesde) As grupoactual, RowNo() As RowNo;

Load * Inline [

ticket,actividad,fechainicio,fechafin,grupodesde,grupohasta

1,inicio,1/20/2010,1/20/2010,,

1,adjunta,1/20/2010,1/20/2010,,

1,transferir,1/21/2010,1/22/2010,g1,g2

1,actualiza,1/22/2010,1/22/2010,,

1,resuelto,1/22/2010,1/22/2010,,

1,transferir,1/22/2010,1/22/2010,g2,g3

1,reanudar,1/22/2010,1/22/2010,,

1,resuelto,1/22/2010,1/22/2010,, ];

NoConcatenate

Final:

Load ticket,actividad,fechainicio,fechafin,

If( IsNull(grupoactual) Or grupoactual = '',Peek(grupoactual),grupoactual) As grupoactual Resident Initial Order by RowNo desc;

Drop table Initial;

Re: Join tables

juan_patrick — Wed, 10 Sep 2014 13:14:04 GMT

Its nearest!

Please see the attached file (example2), the NSD = HD398723, the data correct is the column OK

Re: Join tables

anbu1984 — Wed, 10 Sep 2014 14:59:58 GMT

Try this

Initial:

Load ACTIVIDAD,

NSD,

TIEMPO_TOTAL,

FechaInicio,

FechaRes,

If( NSD <> Previous(NSD),GRUPODESDE,

If( IsNull(GRUPODESDE) Or GRUPODESDE = '',If( IsNull(Previous(GRUPOHASTA)) Or Previous(GRUPOHASTA) = '',Peek(grupoactual),Previous(GRUPOHASTA)),

GRUPODESDE)) As grupoactual, RowNo() As RowNo;

LOAD ACTIVIDAD,

NSD,

TIEMPO_TOTAL,

FechaInicio,

FechaRes,

GRUPODESDE,

GRUPOHASTA,

GRUPO_ACTUAL,

FLAGT,

FROM

(biff, embedded labels);

NoConcatenate

Final:

Load ACTIVIDAD,

NSD,

TIEMPO_TOTAL,

FechaInicio,

FechaRes,

If( IsNull(grupoactual) Or grupoactual = '',Peek(grupoactual),grupoactual) As grupoactual,

RowNo Resident Initial Order by RowNo desc;

Drop table Initial;