topic Re: Set Analysis query in QlikView

Set Analysis query

rahulsingh12 — Mon, 03 Jul 2017 19:57:59 GMT

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,

vishsaggi — Mon, 03 Jul 2017 20:02:37 GMT

Try this?

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

rahulsingh12 — Mon, 03 Jul 2017 20:18:19 GMT

No,

It is not doing the sum.

Regards,

vishsaggi — Mon, 03 Jul 2017 20:25:50 GMT

Try this?

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

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