Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! 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?