Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Expression issue

Hello,

I have a pivot chart with two demensional layers (Territory and Sub-Territory). My expression is correct when I am looking at the sub-territory level. However, when I drill back to look at it on a territory level, the expression is not totaling rows...it is computing on a territory level with is essentially averaging the sub-terriotry values. Is there a way to make this expression sum rows when looking at the top most level?

Thanks,

Jeff