Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum of Sum

Hi,

I have an expression like this-sum(MRP)/conv_rate.this holds good but the Sum is not visible on the top.

If I do Sum(MRP/Conv_Rate) sum is visible but calculation is wrong.

Can anyone suggest me how to get the first expression done with Total visible on the top of the pivot table.

Thanks,

7 Replies
rustyfishbones
Master II
Master II

Try

SUM(TOTAL MRP)/conv_rate

Not applicable
Author

Hi Alan,















I did try the one u said but its not working.What I need is like OH_Units Showing the Sum on top evne for the second expression.

EOMOH_Units=Sum(Total
  MRP_Inv)/Conv_Rate_I_Inv
Total198,177-
06/30/201398,199$156,443.89
03/31/201399,978$171,338.52
andrea_reyes
Contributor III
Contributor III

To solve that problem using the function AGGR  where you specify the dimensions that you are using.

Not applicable
Author

I did use sum(Aggr(Sum(MRP)/Conv_rate,EOM)) but its only showing up total and when I expnad for all other dimensions on the chart it just shows zero.

Thanks,

andrea_reyes
Contributor III
Contributor III

Are there differents Conv_rate to a EOM?

In this Case, Can you use a min or max Conv_rate?

Not applicable
Author

yes.One conv_rate per date.I cant take min or max because it varies as per date.

greg-anderson
Luminary Alumni
Luminary Alumni

What is the SUM for, if you're aggregating MRP but not conversion rate?  What is your intended grouping?