Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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
Highlighted
Partner
Partner

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Highlighted
Partner
Partner

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Creator II
Creator II

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