topic Re: SumProduct in Total in QlikView

SumProduct in Total

narayanamsn — Sat, 16 Nov 2024 21:11:15 GMT

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

Vegar — Sat, 23 Mar 2019 17:14:52 GMT

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/ChartFunctions/InterRecordFunctions/dimensionality.htm

narayanamsn — Sat, 23 Mar 2019 17:21:57 GMT

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

Vegar — Sat, 23 Mar 2019 17:41:01 GMT

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/RangeFunctions/RangeFunctionsInCharts.htm

sunny_talwar — Mon, 25 Mar 2019 11:53:23 GMT

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.