topic Relative % of row total in QlikView

Relative % of row total

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi QV experts!

Hoping to add a column that can provide % CQ product or % of CQ renewals relative to CQ total in this pivot table.

I've tried this expressions:

=sum(if(InQuarter(SalesOrderDate, Today(),0),Amount))

sum(TOTAL(if(InQuarter(SalesOrderDate, Today(),0),Amount)))

However it provides the % relative to cumulative (column) total.

Your help would be much appreciated!

Nagaraju_KCS — Sun, 01 Apr 2018 03:53:01 GMT

May be this,

SUM(Amount)/SUM(TOTAL Amount)

sum(Amount)/above(total sum(Amount)).

SUM(Amount)/SUM(TOTAL <URDimension> Amount)

sunny_talwar — Sun, 01 Apr 2018 16:56:18 GMT

May be this

=Sum(If(InQuarter(SalesOrderDate, Today(), 0), Amount))/

Sum(TOTAL <Theater, Area, SalesManager> (If(InQuarter(SalesOrderDate, Today(), 0), Amount)))

Anonymous — Sun, 01 Apr 2018 22:48:28 GMT

Sunny!! Thank you! You are correct!

The multiple dimensions in the pivot were a little confusing.

Thanks once again for your help!