Custom totals label Qlik Sense

[Anonymous]

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

[Anonymous]

I use Qlik Sense.

[devarasu07]

Hi,

Like this?

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]

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.

[Anonymous]

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

[Anonymous]

Like screen shoot:

[dunnalahk123]

Hi,

You find any solution for above , if so please share it.