Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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?