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: 
Not applicable

absolute sum of subtotals

Hi I have a pivot with the following dimmensions and expressions

Dimmensions = Time (30 minute intervals), Days

Expressions = Applications received (number of apps received during the said time interval)

Applications processed (number of apps processed during the said time interval)

Variance (processed - received / Processed)

In a seperate table I would like to have the absolute sum of variance for the whole day. if possible have that total at the end of the pivot.

WHAT I HAVE
MondayTuesday
08:00 AMApps Received64
Apps Processed43
% Variance2.5%1.7%
08:30 AMApps Received53
Apps Processed33
% Variance1.3%2.0%
09:00 AMApps Received75
Apps Processed62
% Variance4.8%-0.5%
09:30 AMApps Received75
Apps Processed74
% Variance6.0%2.8%
WHAT I NEED
MondayTuesdayMondayTuesday
08:00 AMApps Received6408:00 AMApps Received64
Apps Processed43Apps Processed43
% Variance2.5%1.7%OR% Variance2.5%1.7%
08:30 AMApps Received5308:30 AMApps Received53
Apps Processed33Apps Processed33
% Variance1.3%2.0%% Variance1.3%2.0%
09:00 AMApps Received7509:00 AMApps Received75
Apps Processed62Apps Processed62
% Variance4.8%-0.5%% Variance4.8%-0.5%
09:30 AMApps Received7509:30 AMApps Received75
Apps Processed74Apps Processed74
% Variance6.0%2.8%% Variance6.0%2.8%
Total % Variance14.7%5.9%
Total % Variance
Monday14.7%
Tuesday5.9%


Please help

0 Replies