Need to write similar logic of qlik formula

[kumarleau]

Hello Experts,

I don't know anything about qlik.

My project is migrating from qlik to another BI tool. I want to understand the existing formula of Qliksense

Can someone help on below formula

If anyone can give an outline  sql query that would be a great

Last Segment = num(Sum(Aggr(If([Segment Start Time] = Max(total <[ID: Session]> {<[Participant Purpose] = {'agent','customer'}>}[Segment Start Time]), 1, 0),
[ID: Session], [Segment Start Time])),vFormatCount0)

Regards,

Kumar

[kumarleau]

Hi Experts,  Any suggestions