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: 
Paulius
Contributor II
Contributor II

how to calculate difference from column totals (not rows)

hi all.

have 2 columns , price calculation :

Sum gross / sum quantity.

in columns  Year 2018 another takes Y 2019.

so we can calculate difference, and in one difference column i use "Expression total", and get difference by row and average.

in another column difference i use "Sum of rows", and get sum.

then i can manually make difference from both totals , to get difference.

how to to it automatically ?

attaching example

1 Solution

Accepted Solutions
Paulius
Contributor II
Contributor II
Author

solved. use aggregation in expression.

View solution in original post

1 Reply
Paulius
Contributor II
Contributor II
Author

solved. use aggregation in expression.