topic Logical task in QlikView

Logical task

chinnuchinni — Fri, 22 Jun 2018 05:08:31 GMT

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

emp_id , emp_name

112 , Blenti

113 , sofi

115 , karim

please advice.

kaushiknsolanki — Fri, 22 Jun 2018 05:40:44 GMT

Hi,

You can try this.

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

From XYZ;

Regards,

Kaushik Solanki

chinnuchinni — Fri, 22 Jun 2018 06:08:54 GMT

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 — Fri, 22 Jun 2018 07:18:19 GMT

This adjusting should return your output:

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

From XYZ;

- Marcus