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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

Subtotal in pivot table

Hi Friends , i trying to subtotal at each level , but it is not working , please help .

I am attaching the screenshot.

11 Replies
ToniKautto
Employee
Employee

I am quite confident with that the results you see are accurate, based on your current expression. The result will depend on your dimension, expression, current selection and data model. It is impossible to explain why you get the result you get, or to suggest how you can get the expected result, based on a screenshot.

If the Sum() aggregation is fairly simple this issue can be commonly resolved by applying Aggr() in the below pattern.

Sum( Aggr( Sum(Expression), Dim1, Dim2, ... ,DimN )

Please attach a sample QVW so that dimension, expression, current selection and data model can be considered in more detail.

Anonymous
Not applicable

I expect this result if the expression is without explicit aggregation for example:

1

If it is

sum(1)

the totals will be rather different