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: 
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)