topic Store file using a ticket basis in QlikView

Store file using a ticket basis

rammuthiah — Sat, 16 Nov 2024 19:11:43 GMT

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

Diya which contains Ticket assigned 1,10

Saina which contains Ticket assigned 2,9

which contains Ticket assigned 3,8

which contains Ticket assigned 4,7

which contains Ticket assigned 5,6

Vegar — Sat, 01 Feb 2020 17:56:22 GMT

Try something like this.

Data:

Load Ticket, Name

From Source;

For each _name in fieldvaluelist('Name')

[$(_name)]:

Load
'$(_name) which contains Ticket assigned ' & Concat(Ticket, ',') as Message

Resident Data

Where Name = '$(_name)';

Store [$(_name)] Into [$(_name).qvd] (qvd);

Drop table [$(_name)];

rammuthiah — Sat, 15 Feb 2020 15:01:26 GMT

Even for every single Assignee it shows overall count, not the individual count. Is this possible to rectify it?