Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

tom2qlik
New Contributor III

Straight table calculated total row

Hi All,

My requirement is to have a calculated total different to it's expression.

My expression is simply calling a field and I want the total of this column to be a calculation of two previously calculated expressions.

The Yield target is not a calculated so the total is not correct as can be seen as blank below.

I would like the Yield Target total to be Standard / Target so it would be 59616.55 / 58008.90

I should also point out that the standard and target columns are both expressions.

Thanks,

Tom

1 Solution

Accepted Solutions

Re: Straight table calculated total row

try this expression

SUM(DISTINCT [Target Content])/

(sum(aggr(sum([Target Content])/sum(Yield_Target),Resource,Date)))

15 Replies
laddu_927
Valued Contributor

Re: Straight table calculated total row

Neal, didn't this work [Standard]/[Target]??

Re: Straight table calculated total row

Should be this for Yield Target

Sum(TOTAL [Standard]) / Sum(TOTAL [Target])

tom2qlik
New Contributor III

Re: Straight table calculated total row

Unfortunately not,  unless I've overlooked something the result I got for Standard/Target is 313% as the Total.

That calculation works for the row values but not the total.  The result I should get in the total is 102.7%

Re: Straight table calculated total row

Seems Working?

Num((Sum(Stadard)/sum(Target)),'#,##0.00%')

Capture.PNG

tom2qlik
New Contributor III

Re: Straight table calculated total row

The Standard and Target columns are expressions.

This is my expression....

Standard = SUM(DISTINCT  [Yield.Standard])

Target        = sum(TOTAL [Yield.Standard])/sum(TOTAL Yield.Yield_Target)

Yield_Target =

SUM(DISTINCT  [Yield.Standard])/
(
sum([Yield.Standard])/sum(Yield.Yield_Target))

The result is below

Re: Straight table calculated total row

Is there any dimensions in your report, Would you able to provide qvw for testing

laddu_927
Valued Contributor

Re: Straight table calculated total row

Use the columns in the straight table. You can reference earlier columns in the table,

tom2qlik
New Contributor III

Re: Straight table calculated total row

How can I reference expression columns in a straight table?

tom2qlik
New Contributor III

Re: Straight table calculated total row

Yes here is a test qvw.

Community Browser