Intervalmatch sales and seller

[roberto99]

Hi, I need help I am not able to get what I need
I load these files (they are examples) but the result I get does not place according to the dimension "Tipo" and also does not create the correspondence with Depend

Scrit charge

Horarios:
LOAD Cod_Tie,
Fecha2,
Depend,
Horario_in,
Horario_ou,
Tipo
FROM
[G:\Descargas\Horario_Prueba.xlsx]
(ooxml, embedded labels, table is Hoja1);

Vtas:
LOAD Fecha2,
Num_Doc,
num_id,
Cod_Tie,
vta,
Hora,
Fec_Timestamp1
FROM
[G:\Descargas\Vtas_Prueba.xlsx]
(ooxml, embedded labels, table is Hoja1);

Left Join (Vtas)
intervalmatch (Fec_Timestamp1) LOAD Horario_in, Horario_ou,Depend RESIDENT Horarios;

Left Join (Vtas)
LOAD distinct
Cod_Tie,
Fecha2,
Depend,
Horario_in,
Horario_ou,
Tipo

Resident Horarios ;
drop table Horarios;

for the sum I use the following

Sum(Aggr(Only(vta), num_id))

for dimesion Interval

=if(num(floor(minute(Hora)/30),'')>0,
num(hour(Hora)+floor(Minute(Hora)/30)*30/100,'00:30'),
num(hour(Hora)+floor(Minute(Hora)/30)*30/100,'00:00'))
&' a '&
if(num(floor(minute(Hora)/30),'')>0,
num((hour(Hora)+1)+floor(Minute(Hora)/30)*30/100,'00:00'),
num(hour(Hora)+floor(Minute(Hora)/30)*30/100,'00:30'))

Result desired

Thanks for the help

[Vegar · Accepted solution]

You have this code:

Left Join (Vtas)
intervalmatch (Fec_Timestamp1) LOAD Horario_in, Horario_ou, Depend RESIDENT Horarios;

If you have an KeyField in the load statement  then you should also have the same KeyField in the  intervalmatched data and the intervalmatch() statement. Check out the documentation: https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

[roberto99]

Thanks for the help, I have solved the problem