This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have pivot table. I want to edit total lable, like:
I use Qlik Sense.
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
load * inline [
Sales (In u r expression)
If(Dimensionality()=1,'Total ' & Country & ' ' & num(sum(Sales),'#,##0'),num(sum(Sales),'#,##0'))
Hope this helps you
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: