Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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