Showing text instead of values in a stacked bar chart
I am trying to create a stacking plan in Qlik Sense. A stacking plan is a visual, two-dimensional, or 3D diagram representing the vertical, floor-by-floor occupancy of a commercial building.
I got pretty close using a stacked bar chart with:
stack = floor nr.
bars = rental objects
measure = floor space
However, I am not able to customize what is shown inside the bars. It always shows the measure value (floor space), see attachment. But it would be much more important to show the tenant name. I can show the tenant name in the tooltip, but it would be much better to show it directly in the chart. The width of each box is actually not important, they could all be the same size.
I have tried with dual(), but it still shows the numerical value. I have also seen this video, but this is different, as I have only one measure. Any suggestions on how to achieve this?
Give the dual() another trial by ensuring that the formatting within the properties is set to custom respectively expression-result and not to an automatic.
In QlikView it's working with stacked-bars, too. Therefore I could imagine that's further the case with Sense.
Maybe you tries it with a dummy-application - just a few inline records with simple values of a, b, c and 1, 2, 3 ... and then playing with the chart-configurations (in QV it needs to be set to show the values within the segments). You may detect that any settings is missing/wrong and/or there are to many values and/or they are too long (not enough space within the bars), any NULL stuff ...
