Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ))