Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How can I create a manual total calculation in an expression rather than utilizing the auto total calculation in a straight table in Qlik Sense?
The values in my actual data were all positive. To get the correct grand total, as seen in the screenshot below, I need to do manual calculation. Please give me an advice if you have any. Thanks.
Hello,
In your expression you can use condition
If(Dimensionality() = 0, Expression for Total, Standard expression )
Hi Arek,
Thanks. The expression does work for me. But when I tried to filter by type, the value will be zero. Do you know why this happens?