Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rammuthiah
Creator III
Creator III

Store file using a ticket basis

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.

 

TicketName
1Diya
2Saina
3Neha
4Evangeline
5Rena
6Rena
7Evangeline
8Neha
9Saina
10Diya

 

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
Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

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)];

Next

View solution in original post

2 Replies
Vegar
MVP
MVP

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)];

Next

rammuthiah
Creator III
Creator III
Author

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