Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
chinnuchinni
Creator III
Creator III

Logical task

Hi all,

I have a task.

i have two  tables one is for ticket table and one is employee table.

in ticket table i have ticket id's. in employee table i have emp_ID,emp_name.

with using these two tables,how can we assign the tickets to employees dynamically.

say example:

tickets:

ticket_id

1

2

3

4

5

6

7

emp_id   ,  emp_name

112          , Blenti

113          , sofi

115         ,  karim

please advice.

3 Replies
kaushiknsolanki
Luminary Alumni
Luminary Alumni

Hi,

You can try this.

Load Ticket_ID,Pick(Ceil(3*Rand1),'112','113','115') as EmpID

From XYZ;

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
chinnuchinni
Creator III
Creator III
Author

any other better ways.

like i need to assign 1st 3 tickets to 3 employees,then again it should  repeat.

required o/p

like:

1    112

2    113

3    115

4    112

5    113.....and so on.

Thanks in advance

marcus_sommer
MVP & Luminary
MVP & Luminary

This adjusting should return your output:

Load Ticket_ID, Pick(mod(rowno(), 3) + 1,'112','113','115') as EmpID

From XYZ;

- Marcus