Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

Help with set analysis expression

I have expression

if([%Link Pump Group]<>[DYN Pump Group Id] and [Pump ID]=[DYN Pump Id] and  IsNull([DYN Pump Param Id])=0,[Pump ID])

this expression gives the Pump Ids

I just want to sum the volume for above pump ids .

How to write this expression in set analysis . Please help

1 Reply
MK_QSL
MVP
MVP

=SUM({<

  [%Link Pump Group] = {"=[%Link Pump Group] <> [DYN Pump Group Id]"},

  [Pump ID] = {"=[Pump ID] = [DYN Pump Id]"},

  [DYN Pump Param Id] = {'*'}

  >}Volume)