Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
narayanamsn
Creator
Creator

SumProduct in Total

Hi,

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

 

Categoryforecastactualerror%Formula
a101217%abs(forecast-actual)/actual
b151050% 
c202520% 
Total4547102%sum product(error%: actual)/actual

 

@sunny_talwar @jagan 

Labels (1)
4 Replies
Vegar
MVP
MVP

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
Creator
Creator
Author

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

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.