Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to concatenate Field value & free Text

In pivot table i want to show 'Total of Pqr & Total of Xyz'.

I have writtent an expression

if(Dimensionality()=0, 'Total of ' & Leader2) indicated in red mark below screenshot.

I want to concatenate 'Total of ' with column Leader2. Please help me on this?

Also sample Qlikview file is attached for reference.

123d.png

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You cannot customize the labels for the subtotals. All the subtotal labels in a dimension will get the same text value. You cannot use dimension values for subtotal labels. Maybe you can use the approach from this discussion as an alternative: Custom Labels in Pivot Table


talk is cheap, supply exceeds demand
anbu1984
Master III
Master III

146850.png