Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
try this expression
SUM(DISTINCT [Target Content])/
Neal, didn't this work [Standard]/[Target]??
Should be this for Yield Target
Sum(TOTAL [Standard]) / Sum(TOTAL [Target])
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%
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)
SUM(DISTINCT [Yield.Standard])/ (sum([Yield.Standard])/sum(Yield.Yield_Target))
The result is below
Is there any dimensions in your report, Would you able to provide qvw for testing
Use the columns in the straight table. You can reference earlier columns in the table,
How can I reference expression columns in a straight table?
Yes here is a test qvw.