Qlik Community

QlikView Documents

Documents for QlikView related information.

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.

Variance in the Sub Total

mark6505
Valued Contributor III

Variance in the Sub Total

Good Afternoon

This might be common knowledge, just I haven't seen it before and I couldn't find a post about it when I looked.

I found away to replace the the Partial sum value in a pivot table to anything you like

Mark

Comments
qleonerd
New Contributor

Not Bad~but i suggest that you can use Dimensionality()

msteedle
Contributor

If(Dimensionality() = 2,

  Sum(Value),

  Sum({<Year = {2015}>} Value) - Sum({<Year = {2014}>} Value))

Version history
Revision #:
1 of 1
Last update:
‎12-10-2015 08:49 AM
Updated by: