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

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Remove max and aggr from the given set expression

Hello

I am trying to remove max and aggr from the below set expression but getting syntax errors. Please advise

sum(aggr(pick(match([Currency],'Transactional','Functional','Reporting') ,[Sell Price],

  [Sell Price] * max({<[Revenue Schedule Type]= {'RPRO-REVENUE'}>} [Trans Exchange Rate]),

  [Sell Price] * max({<[Revenue Schedule Type]= {'RPRO-REVENUE'}>} [Trans Exchange Rate]) *

  max({<[Revenue Schedule Type]= {'RPRO-REVENUE'}>} [Trans Reporting Exchange Rate]) ),[Transaction ID]))

Thanks

Labels (1)
0 Replies