Urgent - Help required in HeatMap sizing

[sayadutt]

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!!!!

[Kushal_Chawda]

Can you share the sample application?