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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

use of total when fabs is used

Sum (TRX)/(Sum(TOTAL(TRX))/Count(DISTINCT(ZIP_CODE)))  - this formula works fine but i am facing issues when i replicate this formula in another expression which is

fabs(Sum(TRX)-(Sum ({$<WEEK_END_DATE={"$(=date( max(WEEK_END_DATE)-7))"}>}TRX)))

/

(sum(TOTAL(fabs(Sum(TRX)-(Sum ({$<WEEK_END_DATE={"$(=date( max(WEEK_END_DATE)-7))"}>}TRX))))))/ (Count(DISTINCT(ZIP_CODE)))


can anyone tell me where im going wrong, the formula does  not show an error

2 Replies
Not applicable
Author

Could you send sample qvw file?

CELAMBARASAN
Partner - Champion
Partner - Champion

Sum over the sum is not possible.

Can you tell me what is your requirement?

Aggr is the only way to use sum over the sum like

Sum(Total Aggr(Fabs(Sum(FieldName)), DimField))