Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jdmarlin
Contributor III
Contributor III

Divide two columns w/ 'Sum of Rows'

I have two columns with the total represented as the 'Sum of Rows'

I'm trying to get the % change by using this expression: Column(4) / Column(3) - 1, but it's using the expression totals rather than the totals shown in the table.

How do I get QlikView to use the row totals in the table rather than the expression totals?

Thanks!

ex.jpg

1 Reply
Gysbert_Wassenaar

That depends on the expressions your table uses. But you won't be able to use the Column function.

What are the dimensions and what are the measures?


talk is cheap, supply exceeds demand