Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have pivot table. I want to edit total lable, like:
I use Qlik Sense.
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
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.
I am using option Show totals in Qlik Sense. I want to write expression in Totals label. Can you help me?
Like screen shoot:
Hi,
You find any solution for above , if so please share it.