Hi Team,
I have developed one HeatMap based on the highlighted Division and ProjectName from my datasheet.
Division ProjectName Employees_Working
A xxx 5
A yyy 3
B abc 10
B qwe 4
B asd 5
C efg 3
<likewise>
Now I have used Division and ProjectName as HeatMap Dimensions and Expression as Count(ProjectName). It works fine and created the heatmap.
Enhancement which I am looking for:
Currently the HeatMap Block sizes are not based on any criteria and I believe we let the Qlikview decide the width and length.
Can we make it dynamic based on below logic:
From Employees_Working field we see we have (5+3+10+4+5+3) 30 employees.
Division
A has (5+3) 8 employees
B has (10+4+5) 19 employees
C has 3 employees
So, A, B and C should have the respective areas allocated
A area should be 8/30 (employees of A Division divided by Total employees)
B area should be 19/30 (employees of B Division divided by Total employees)
C area should be 3/30 (employees of C Division divided by Total employees)
Once that is plotted, projects inside the division should also be allocated accordingly based on number of employees.
For example inside A, we have 2 projects xxx (5 employees) and yyy(3 employees)
So, for 2nd dimension ProjectName, we should allocate 5/8 area for Project xxx (employees on project xxx divided by total employee on Division A)
we should allocate 3/8 area (employees on project yyy divided by total employee on Division A)
Thanks in advance!!!!
