Dot matrix chart for absolute numbers (not %)

gcairney — Thu, 13 May 2021 13:30:09 GMT

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

Re: Dot matrix chart for absolute numbers (not %)

rwunderlich — Thu, 13 May 2021 20:20:25 GMT

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

topic Re: Dot matrix chart for absolute numbers (not %) in QlikView

Dot matrix chart for absolute numbers (not %)

Re: Dot matrix chart for absolute numbers (not %)