Urgent - Help required in HeatMap sizing

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

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

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

Re: Urgent - Help required in HeatMap

Kushal_Chawda — Mon, 28 Mar 2016 08:00:48 GMT

Can you share the sample application?