Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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