Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
berryandcherry6
Creator III
Creator III

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

Regards,

10 Replies
berryandcherry6
Creator III
Creator III
Author

HI,thanks for reply

Can you please show me some code for above logic.

Regards