Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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.