Discussion board where members can get started with QlikView.
For eg. I have 10 tickets assigned to 5 members 2 tickets per member. I need to read those names, ticket no using for loop
and store as separate file for each member by stating the message as "You have TCT1, TCT2" in your bucket.
I want to store like Diya.xlsx, Reena.xlsx and so on which contains
Try something like this.
Load Ticket, Name
For each _name in fieldvaluelist('Name')
Load'$(_name) which contains Ticket assigned ' & Concat(Ticket, ',') as Message
Where Name = '$(_name)';
Store [$(_name)] Into [$(_name).qvd] (qvd);
Drop table [$(_name)];
View solution in original post
Even for every single Assignee it shows overall count, not the individual count. Is this possible to rectify it?