Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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