Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pinkzfairy
Contributor II
Contributor II

Summary/Total by Dimension Based From Many Expression

Hello,

I want to get summary/total by dimension, but the data quite complicated because it's actually results from many other expressions.

This is the screen shot where the "Total KPI Value MD YDT YO" is my goal, but right now the result is zero. I want to get the result like the number in red.

QVW.jpg

The "Total KPI Value MD YDT YO" that i want is the summary/total from "KPI Value MD YDT YO" by "Sales Force".

But the "KPI Value MD YDT YO" is actually calculation results from many other expressions.

I also attach the QVW file to explain the calculation.

Really really appreciate if anyone could help me on this.

Thanks a lot

0 Replies