How to merge cells and provide information in the middle

[Paknanarn23]

I want to merge the Average Horizontal column cells of each machine.

I want the information to be displayed like this. What should I do?

[levente81]

Hi Paknanarn23,

As far as I know the outcome you aim to develop is not possible in Qlik Sense.

I would say this is a granularity issue... when you specify granularity by certain dimensions then you can not expect to create a measure with an alternative granularity...

What you might be able to do with this is concatenating values of those dimensions ("Resistance_Ohm" and "Column 1" in your screenshot) that are causing too high level of granularity - this way the measure can work on the preferred granularity level.

If the requestor could agree with alternative visualization, you might challenge this request and look after some better solution among native tools of Qlik Sense.