Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
NA7
Contributor
Contributor

Sub total in Qlik sense straight table

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

1 Reply
Clement15
Partner - Specialist
Partner - Specialist

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 ))