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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rahulsingh12
Contributor III
Contributor III

Set Analysis query

Hi,

I have 2 fields SalesID,CSRID

SalesID will have all the CSRID  as well as some unique SalesID.

when I make a selection in SalesId the corresponding values in CSRID  are selected.

Is there a way to write an expression such that no matter what SalesID I Choose it will work only on values of csr and ims iD.

count({$<SalesID=,>}{$<CSRid=p(SalesID)>} if(CSRid=SalesID'some value'))

So here what I want is if in the current selection in csrid is in salesId the if that is equal to salesid then count some value.

Even if I select SalesID first then the corresponding CSRID it should neglect the current selected SalesID value.

Regards,

3 Replies
vishsaggi
Champion III
Champion III

Try this?

=  Sum(Aggr(Count({$< CSRid = p(SalesID), SalesID= >} if(CSRid = SalesID, 1)), CSRid))

rahulsingh12
Contributor III
Contributor III
Author

No,

It is not doing the sum.

Regards,

vishsaggi
Champion III
Champion III

Try this?

=  Count({$< CSRid = p(SalesID), SalesID= >} if(CSRid = SalesID, 1))


If not can you share your expected output with a sample file here?