Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Modify the total of 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 4 expressions.

this is a YoY comparison.

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

Untitled.png

6 Replies
swuehl
MVP
MVP

Try something like this in your expressions:

=If(Dimensionality()=0,

     YourPercentageIncreaseExpressionInTotalLine,

     YourDetailsLineExpression

)

satishkurra
Specialist II
Specialist II

Use the below expression

if(Dimensionality()>0,

sum(SalesAmount),

Num(sum(SalesAmount),'#,##0.00%'))

Set the expression to default in Number Tab

satishkurra
Specialist II
Specialist II

Sorry, i didn't see when replying the question, i see after submitting, Apology

swuehl
MVP
MVP

No problem, that happens quite often because it's hard to see if there are replies coming in while typing.

Keep on Qliking...

Not applicable
Author

This group is awesome.

Not applicable
Author

That works, i tested with the values hardcoded, but another issue that i have is that i am using calculated dimension. how can I refer it in expression.