Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.