Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
hoangpm8
Contributor III
Contributor III

Custom totals label Qlik Sense

I have pivot table. I want to edit total lable, like:

Untitled11.png

5 Replies
hoangpm8
Contributor III
Contributor III
Author

I use Qlik Sense.

devarasu07
Master II
Master II

Hi,

Like this?

200.png

Data:

LOAD * INLINE [

    Country, Salesman, Year, Sales

    Australia, Rolf Wesenlund, 2005, 1030

    Australia, Rolf Wesenlund, 2006, 1210

    Belgium, Charles Ingvar Jonsson, 2006, 1210

    Belgium, Charles Ingvar Jonsson, 2008, 3159

    Belgium, Charles Ingvar Jonsson, 2009, 3690

    Belgium, John Cleaves, 2008, 2550

    Belgium, Tony Cedholt, 2008, 2500

    Belgium, Tony Cedholt, 2009, 4249

];

Fields:

load * inline [

Field

Country

Salesman

Year

Sales

];

Sales (In u r expression)

If(Dimensionality()=1,'Total ' & Country & ' ' & num(sum(Sales),'#,##0'),num(sum(Sales),'#,##0'))

Hope this helps you

Regards,

Deva

OmarBenSalem
Partner
Partner

To explain what dimensionlity() is; , to put it in simple words, It's the 'position' of our dimensions.

In the table that Devarasu shared (gret work by the way), he works with 3 dimensions:

1) Coutry => Dimensionality()=1

2) SalesMan => Dimensionality()=2

3) Year => Dimensionality()=3

As for the total (first row); It's Dimensionality()=0.

With knowing that, we can take the customization of our tables to a whole new level !

Hope that was clear enough.

hoangpm8
Contributor III
Contributor III
Author

I am using option Show totals in Qlik Sense. I want to write expression in Totals label. Can you help me?

Capture12.PNG

hoangpm8
Contributor III
Contributor III
Author

Like screen shoot:

Untitled13.png