Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Totals Question

I have a Straight Table with Type, Channel, Target, Actual.  The Actuals accumulate over time but the Target is set once a year.  In the table, I take the min(target), and then sum(actuals).  But when I total, I can't get the targets to add up, they too are giving me the min. 

=num(min(Target),'#,##0.0',)

 

I am doing Sum of Rows on the Expressions tab.

 

 

   

TypeChannelTargetActual
BranchArkansas1813
BranchCentral Florida3416
BranchGeorgia3620
BranchGr Wash3632
BranchGreater Atlanta3724
BranchIn-Store3816
BranchNorth & South Carolina4222
BranchOther4635
BranchSFlorida4842
BranchSoutheast5924
BranchTotal18246

 

0 Replies