Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Bart_Breekveldt
Contributor III
Contributor III

Grand Total below table or highlight it

Dear community,

If I select Grand Total ('Totalen') for an dimension, I automatically get these at the top of the table.

We're switching from MS Excel to Qlik Sense for dashboards, and my supervisor want it to look the same as Excel (format)

However we want this below the table or highlighted (as second best option, if below the table isn't an option)

Is it possible to put the Grand Total below the table or highlight it?

Grand Total Qlik.PNG

Labels (3)
2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

in Qlik builtin pivot table i am not aware of the possibility to change the total row location 

you can use this expression in the background of your measures  

if(Dimensionality()<> min(dimensionality()),lightgray())

it will color all total row at any level in gray in this case 

Bart_Breekveldt
Contributor III
Contributor III
Author

Thanks at first,

I'm only known with the IF-function, I haven't used the other functions in my few months of Qlik experience. How do I integrate this function  with an statement containing fields so I can integrate other fields myself in the future? Below is my expression:

=ConsumentGroep&' - '&[cgroep.Naam]   (this translates to ConsumerGroup&' - '&cgroup.Name)

Can you help me? Much thanks.