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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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 ))