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
