Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.