Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
pinkzfairy
New 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