Dot matrix chart for absolute numbers (not %)

[gcairney]

Hi , We would really love to feed our real time hospital data into a visualisation like below . For each bed on ward we want to indicate whether it occupied either by a planned or non planned (emergency) or is not occupied at all. We have the data but so far have only been able to develop n infographic that shows the % of each bed type, not the absolute number. Would love to figure out a way to reflect the relative differences in size of wards (some may have 8 beds , some may have 35...knowing that a ward is 50% unoccupied isn't that helpful when it may only have 8 beds to start with !).

Any advice / suggestions gratefully received ! Thanks in advance , Gary

[rwunderlich · Accepted solution]

I would think you could do this with a Grid Chart. 

DImensions:
Ward
Bed#

Expression:
=1

Expression background color is set by occupancy status. 

You may have  to assign sequential bed numbers to use as the x-axis.  You can do that in the script with

AutoNumber(BedId, Ward) as BedSequence

You can also do some cool grids with Pivot Tables. See https://qlikviewcookbook.com/2015/11/pivot-table-grids/ and https://qlikviewcookbook.com/recipes/download-info/pivot-table-grids/

-Rob