Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Text Beside Total

Hi ,

How to include the text beside the total.

Below is the image for reference.

Untitled.png

Thanks..

3 Replies
Vegar
MVP
MVP

You could laborate with the dimensionality() function. See picture below where I am using " if(Dimensionality()=0,'Total sales ')  & sum (Sales)" as an expression.

Text besides total.PNG

Cheers

Vegar

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

annafuksa1
Creator III
Creator III

you can change it at presentation tab in chart properties

label.png

Anonymous
Not applicable

vegar.lie.arntsen‌ Is on the right track with dimensionality...

This worked on my side:

if(Dimensionality()<>0,
Sum(Sales)
,
Sum(Sales) & ' Sales')