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

use running total in straight table

Hi,

I am trying to modify the totals of a straight table.

Basically i have a straight table with one dimension(the dimension has only 2 values and it is a calculated dimension) and 4 expressions.

this is a YoY comparison.

instead of totals at the bottom i want the percentage increase as shown below

Untitled.png

I have used the below solution as suggested by swuehl

=If(Dimensionality()=0,

    YourPercentageIncreaseExpressionInTotalLine,

    YourDetailsLineExpression

)

but i am stuck at that "YourPercentageIncreaseExpressionInTotalLine," is based on the "YourDetailsLineExpression" so how do i refer to that

is there a runing total to be stored in variable or something on those lines.

1 Reply
sunny_talwar

Is there a sample you can share to look at the issue?