Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Subtotals when using an expression

Hi,

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.

Archie

Subtotals for Average(Full Cost).PNG.png

Tags (1)
2 Replies
wgonzalez
Contributor

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

Chris

Community Browser