Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

janardhan
Contributor

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
MVP
MVP

Re: set analysis with aggr

Try this:

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

2 Replies
MVP
MVP

Re: set analysis with aggr

Try this:

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

janardhan
Contributor

Re: set analysis with aggr

Thanks sunny...