Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Subtotals when using an expression


I seem to be having a problem with getting my subtotal to work for a calculated field in a straight table.

The calculated field is an average of full cost.

The subtotals is showing me the average of the full cost for all rows instead of the total.

Please see below settings on Presentation tab for this field and let me know if I missing anything.

Thanks for your help.


Subtotals for Average(Full Cost).PNG.png

Tags (1)
2 Replies

Re: Subtotals when using an expression

Try this: Full Cost / sum(TOTAL Full Cost)  This will be Average column.

Not applicable

Re: Subtotals when using an expression

Hi Archie,

In "Expression" tab (properties), you can either check :

- total (which execute expression)

- average

best regards


Community Browser