SumProduct in Total

[narayanamsn]

Hi,

How to get Sum Product only for Total row while other rows have simple formula.

Category	forecast	actual	error%	Formula
a	10	12	17%	abs(forecast-actual)/actual
b	15	10	50%
c	20	25	20%
Total	45	47	102%	sum product(error%: actual)/actual

@sunny_talwar @jagan 

[Vegar]

You can solve it by using Dimensionality().
If( Dimensionality()=0, your total expression, your ordinary expression)

Read more about dimensionality here:
https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunctio...

[narayanamsn]

How to get sum product as qv does not have this function?

[Vegar]

I'm more experienced in Qlik syntax than other languages, could you please explain what you are trying to accomplish with "Sum product"?

Maybe it is related to what Qlik range functionality can offer? https://help.qlik.com/sv-SE/sense/November2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Range...

[sunny_talwar]

What exactly are you doing to get 102% here? I tried if things in Excel to determine your calculation behind 102%, but couldn't figure it out.