Set Identifier

[dinicholls]

Hi all,

I think I may be confusing myself!

I have the following expression, as a dimension:

=if(Aggr(Rank(Sum({1<CustomerLink, AOM={'Andrew Rayland'}, ME={$(VarME)}>} [Line Debt])), CustomerLink)<=10,CustomerLink,Null())

Works exactly as I want it to, until a user selects something.

I was under the impression, that using a '1' after { and before <, would mean that QlikView would ignore any selections and use all the data stored in the document?

Where am I going wrong?!

Thanks

Di

[sunny_talwar]

What is your expression here? Assuming it is Sum(Measure), change that to Sum({1} Measure)

[tresesco]

Try like:

=if(Aggr(Rank(Sum({1<CustomerLink, AOM={'Andrew Rayland'}, ME={$(VarME)}>} [Line Debt])), CustomerLink)<=10,only({1}CustomerLink),Null())