Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
luisgm89
New Contributor

Concatenate dimension value in Pivot Table measure label

Hello,

I am pretty new to Qlik Sense, and I am losing my mind to achieve something.

I want to concatenate a dimension value in a measure label when using a Pivot table. The reason for this is that when users export the data table, the format in Excel is not very user friendly (The date dimension label is shown as a Merged cell for all measures, so sometimes it is kind of difficult to find a single measure for a single date in the excel).

Look at this screenshot as an example, I have marked in red the desired result:

Pivot.png

Is this something that can be achieved in the pivot table with the out of the box pivot table component?

Thanks!

Luis

1 Reply
Digvijay_Singh
Honored Contributor III

Re: Concatenate dimension value in Pivot Table measure label

Looks like not possible, expression is allowed in measure label but it has to use Aggregation functions like Max/MaxString to fetch single value from dimensions else it will show nulls.