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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
avastani
Partner - Creator III
Partner - Creator III

Straight Table - Expression Total

Is it possible to use Expression Total for one expression, Sum of Rows for the Total for a second expression and then use Sum of Rows total/ Expression total in a third expression?

For instance

Sum(Sales) - Expression 1 has expression total

Sum(Cost) - Expression 2 has expression total

FABS(Sum(Sales) - Sum(Cost)) has Sum of rows total

FABS(Sum(Sales) - Sum(Cost))/Sum(Sales) ===> I want to do this but QV computes an incorrect total using Expression Total for everything.

0 Replies