topic Modify the total of straight table in QlikView

Modify the total of straight table

Tue, 29 Mar 2016 19:01:37 GMT

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

Re: Modify the total of straight table

swuehl — Tue, 29 Mar 2016 19:15:39 GMT

Try something like this in your expressions:

=If(Dimensionality()=0,

YourPercentageIncreaseExpressionInTotalLine,

YourDetailsLineExpression

)

Re: Modify the total of straight table

satishkurra — Tue, 29 Mar 2016 19:17:39 GMT

Use the below expression

if(Dimensionality()>0,

sum(SalesAmount),

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

Set the expression to default in Number Tab

Re: Modify the total of straight table

satishkurra — Tue, 29 Mar 2016 19:18:22 GMT

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

Re: Modify the total of straight table

swuehl — Tue, 29 Mar 2016 19:22:59 GMT

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

Keep on Qliking...

Re: Modify the total of straight table

Tue, 29 Mar 2016 19:31:44 GMT

This group is awesome.

Re: Modify the total of straight table

Wed, 30 Mar 2016 12:12:28 GMT

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.