topic Re: Grand Total below table or highlight it in App Development

Grand Total below table or highlight it

Bart_Breekveldt — Sat, 16 Nov 2024 20:36:11 GMT

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?

Re: Grand Total below table or highlight it

lironbaram — Mon, 24 Jun 2019 11:06:17 GMT

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

Re: Grand Total below table or highlight it

Bart_Breekveldt — Mon, 24 Jun 2019 11:31:38 GMT

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.