Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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