QlikView Looping and Allocating.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a field Redeemed where the user will redeem the points. Now I have to allocate these redeemed points to the projects which he worked. For every project we need to allocate only 20 points. How can I divide and allocate the points to the projects? For example, if a user redeemed 85 points in the month of April. If he worked on following projects from Jan P1 and P2 and Feb P3 and P4 and Mar P5.

Projects worked by every user will vary.

Earned by the User 1: 85

	Redeemed
	Jan	Feb	Mar	April
P1				20
P2				20
P3				20
P4				20
P5				5

Re: QlikView Looping and Allocating.

marcelviegas — Fri, 04 May 2018 20:23:39 GMT

attach your qvw for better understanding

Re: QlikView Looping and Allocating.

Anil_Babu_Samineni — Mon, 07 May 2018 06:30:03 GMT

Difficult to say without knowing your data set and result set?

topic QlikView Looping and Allocating. in QlikView

QlikView Looping and Allocating.

Re: QlikView Looping and Allocating.

Re: QlikView Looping and Allocating.