Problem to filter two intervals of different dates with the same filter Year

ivan_revuelta — Wed, 14 Nov 2018 10:57:33 GMT

Hello,

I'm a rookie at Qlik and I need help. Looking in the forum I have managed to load a script that allows me to see the courses that are active between two dates through the Year filter: (This part does it well)

The problem is that I need to filter also by the group in which the teachers were at that moment. That is, in addition to filter by Start date (Fecha inicio) and End date (Fecha fin), I also need to do so by the fields memberStartDate(miembroDesde) and memberEndDate(miembroHasta). I do not know how to do it...

This is my script:

[cursos]:

LOAD

codigoCurso,

curso,

Date(Date#([fechaInicio], 'DD/MM/YYYY') ) AS [fechaInicio],

Date(Date#([fechaFin], 'DD/MM/YYYY') ) AS [fechaFin],

profesor

FROM [lib://AttachedFiles/Cursos.csv]

(txt, codepage is 28591, embedded labels, delimiter is ';', msq);

[profesores]:

LOAD

profesor,

Grupo,

Date(Date#([miembroDesde], 'DD/MM/YYYY') ) AS [miembroDesde],

Date(Date#([miembroHasta], 'DD/MM/YYYY') ) AS [miembroHasta]

FROM [lib://AttachedFiles/profesores.csv]

(txt, codepage is 28591, embedded labels, delimiter is ';', msq);

MinMaxDate:

Load

RangeMin(Min(fechaInicio),Min(fechaFin)) as MinDate,

RangeMax(Max(fechaInicio),Max(fechaFin)) as MaxDate

Resident cursos;

Let vMinDate = Num(Peek('MinDate',0,'MinMaxDate'));

Let vMaxDate = Num(Peek('MaxDate',0,'MinMaxDate'));

Drop Table MinMaxDate;

Calendar:

Load

Date(TempDate) as Date,

Month(TempDate) as Month,

Year(TempDate) as Year,

Date(MonthStart(TempDate),'DD/MM/YYYY') as MonthYear;

Load

$(vMinDate)+IterNo()-1 as TempDate

AutoGenerate 1

While $(vMinDate)+IterNo()-1 <= $(vMaxDate);

IntervalMatch(Date)

Load fechaInicio, fechaFin Resident cursos;

Re: Problem to filter two intervals of different dates with the same filter Year

dplr-rn — Wed, 14 Nov 2018 15:48:07 GMT

Hi Ivan

i believe you will need to use set analysis on your table

something like miembroDesde ={"<=$(Max(Date))"}, miembroHasta={"<=$(Max(Date))"}

if you can share a sample app i can help further

Re: Problem to filter two intervals of different dates with the same filter Year

ivan_revuelta — Mon, 19 Nov 2018 16:13:07 GMT

Hi,

I just uploaded a sample app.

Many thanks

topic Re: Problem to filter two intervals of different dates with the same filter Year in QlikView

Problem to filter two intervals of different dates with the same filter Year

Re: Problem to filter two intervals of different dates with the same filter Year

Re: Problem to filter two intervals of different dates with the same filter Year