topic Show Totals for a Dimension on a Straight Table in App Development

Show Totals for a Dimension on a Straight Table

pedrohenriqueperna — Thu, 07 Aug 2025 14:41:12 GMT

Hi,

I have a straight table that holds some dimensions that I'm trying to display a count in the totals row.

There are plenty rows, and I need to count the total displayed in the table. The problem is dimensions don't have a total config/option, only measures. If I use a measure and remove the dimension, my table breaks as there are no dimensions to wrap the data.

I've tried using Dimensionality(), but it doesn't work, although it displays the dimensions normally through the rows, except the total:

=If(IsNull(dataEntrega),
If(Dimensionality() = 0, Aggr(Count(id_conhecimento), id_conhecimento), id_conhecimento
)
)

I've searched a bit and found out it could work on pivot tables, but I need to use a straight table.

Is there a workaround?

Thanks in advance.

Re: Show Totals for a Dimension on a Straight Table

Oleg_Troyansky — Thu, 07 Aug 2025 15:11:21 GMT

As a workaround, even though not ideal, you could add the counts to the dimensions' labels, since adding them to the total line for dimensions doesn't seem to be possible.

Cheers,

Oleg Troyansky

Re: Show Totals for a Dimension on a Straight Table

pedrohenriqueperna — Thu, 07 Aug 2025 15:52:00 GMT

Hi, Oleg

Indeed that's a workaround, but unfortunately it won't fit my needs.

Thanks for the reply anyway.

In case anyone is interested, I've managed to add it by using a CSS helper that I use to edit the css of my dashboards objects. The html structure is the same for dimensions, so I added it using :before. It's far from the ideal, but I can add dynamic values by using variables. It goes something like this:

.sc-dEAvcG div:nth-child(1) div:nth-child(1) div:nth-child(1) div:nth-child(2) div:nth-child(1) div:nth-child(5) span:nth-child(1)::before {
content: "0"; /you can expand a variable holding the value you wish to display
}

You could also add more css rules to match the other total values style.

Re: Show Totals for a Dimension on a Straight Table

vkramBI4Qlik — Thu, 07 Aug 2025 16:01:11 GMT

Dimensionality works better on Pivot table. Did you try to convert the table to Pivot table with fully expanded and use the dimensionality ?

Thanks.

Re: Show Totals for a Dimension on a Straight Table

pedrohenriqueperna — Sun, 05 Oct 2025 16:16:07 GMT

Hi,

I thought about it, but I've had already customized the table too much using the css helper. I'd have had to redo all the work cause the structure and tags and pretty different between them.

I'll have a try next time I need to build something likely. Thanks for the tip