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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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