Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Jeevanar
Contributor II
Contributor II

Getting the sum without using Aggr function

Hello

I have scenario

I need the total without using the aggr function

 

Jeevanar_0-1640541168268.png

 

A  expression is = 1/3/stdev(S_ERR/S_TOL_ISO)

B expression is = sum(aggr(1/3/stdev(S_ERR/S_TOL_ISO),LAB,TrackingGeneratingMachine,CODEF2,INDICE,PRODUCT_CODE))

 

I want to achieve the result of B without using aggr function is this possible.

Labels (3)
1 Reply
Vegar
MVP
MVP

If you are trying to achieve this in a QlikView straight table, then you will have the option to change your expression totaling  from the default expression totaling to sum og rows. I believe that totaling method  will help you to get rid of the aggr() in your expression.