How to seperate and allocate the points in QlikView

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

topic How to seperate and allocate the points in QlikView in QlikView

How to seperate and allocate the points in QlikView