Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

anuhegde
New Contributor III

Total function in the table properties

Greetings to all!!

                                                                                    

In the straight table properties, total function is set to auto.

In that table,there is only one row and the values in this row and the totals row is different. Is this beacuse of auto? what might be the reason for this?

The expectation is to get the same values in the totals row as the below row.

Attached the screenshot for the better understanding.

2 Replies
zebhashmi
Valued Contributor

Re: Total function in the table properties

Yah should not be that. what is your expression for this?

omarbensalem
Esteemed Contributor

Re: Total function in the table properties

you can control the total expression by using the dimensionality() function.

In fact, try to change ur expression as follow:

if(dimensionality()=0, NewExpressionForYourTotals, YourExpression)

please refer to this:

How to use - Dimensionality()