topic Re: Sub total in Qlik sense straight table in Data Movement & Streaming

Sub total in Qlik sense straight table

NA7 — Wed, 19 Mar 2025 21:46:28 GMT

Hi,

Is there a possibility where we can show only subtotal for a flag field (+ve and -ve values) and display it in the bottom of the table in qlik sense.

No other row should have any values, only the label and total should apper.

Kindly help me with this requirement

Clement15 — Tue, 10 Dec 2024 14:16:21 GMT

Hello,

You can not put a dimension and use the aggr and total in your measure. This will only put one row in your table with a custom measure.

For example :

AVG( total aggr( sum(CA) , customer ))