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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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)