Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey, maybe you techs could help me by coding some sheets.
My goal is to have the pausedMinutes from table 1 in table 2. It could be that there is more than one actionID Pause, so i have to sum the pause minutes in table 1. After that, we can save it in table 2.
I don't know how to do this. Maybe someone could help.
Thanks
Table2: LOAD TicketNummer, ID1 FROM [lib://Qlik Community/2.xlsx] (ooxml, embedded labels, table is Sheet1); Left Join (Table2) LOAD TicketNummer, Sum(Pause) FROM [lib://Qlik Community/1.xlsx] (ooxml, embedded labels, table is Sheet1) Group By TicketNummer;
Check this out if you will and see if it works as you intended.
Regards,
Tim P.
Table2: LOAD TicketNummer, ID1 FROM [lib://Qlik Community/2.xlsx] (ooxml, embedded labels, table is Sheet1); Left Join (Table2) LOAD TicketNummer, Sum(Pause) FROM [lib://Qlik Community/1.xlsx] (ooxml, embedded labels, table is Sheet1) Group By TicketNummer;
Check this out if you will and see if it works as you intended.
Regards,
Tim P.
Thanks, that helps.