Using set analysis inside loop in Load editor in qlik
Hi,
I have a requirement where i need to get counts of Invitation according to date and ClientID, for every client. Here how could i put or approach to solve this?
I usually in front end for particular client i put expression like this
SUM({$< clientID = {'15'}>}Invitation)
But i need to get for all clients present in Client table by putting in Load Editor.
How could i do this? Any kind of help , suggestion are Appreciated
