topic Text Beside Total in QlikView

Text Beside Total

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

How to include the text beside the total.

Below is the image for reference.

Thanks..

Re: Text Beside Total

Vegar — Thu, 05 Jan 2017 08:34:44 GMT

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

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.

Re: Text Beside Total

annafuksa1 — Thu, 05 Jan 2017 13:51:45 GMT

you can change it at presentation tab in chart properties

Re: Text Beside Total

Anonymous — Thu, 05 Jan 2017 14:04:22 GMT

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

This worked on my side:

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