Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

Relative % of row total

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.

QV-q relative %.JPG

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!

1 Solution

Accepted Solutions
Highlighted

Re: Relative % of row total

May be this

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

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

View solution in original post

3 Replies
Highlighted
Valued Contributor II

Re: Relative % of row total

May be this,

SUM(Amount)/SUM(TOTAL Amount)

OR

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

OR

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

Highlighted

Re: Relative % of row total

May be this

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

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

View solution in original post

Highlighted
New Contributor III

Re: Relative % of row total

Sunny!! Thank you! You are correct!

The multiple dimensions in the pivot  were a little confusing.

Thanks once again for your help!