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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
janardhan
Creator
Creator

set analysis with aggr

Hi friends ,

I am trying to exclude some fields using set analysis with aggregation function

Below syntax is correct ? can anyone give some hints

sum(aggr({<Provider=>} (Only (Quantity)),[Search Id]))

Thanks in Advance

Janardhan

1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

Try this:

Sum({<Provider>} Aggr(Only({<Provider>}Quantity),[Search Id]))

View solution in original post

2 Replies
sunny_talwar
MVP
MVP

Try this:

Sum({<Provider>} Aggr(Only({<Provider>}Quantity),[Search Id]))

janardhan
Creator
Creator
Author

Thanks sunny...