topic Re: Set Identifier in QlikView

Set Identifier

dinicholls — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Set Identifier

sunny_talwar — Wed, 29 Mar 2017 12:51:50 GMT

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

Re: Set Identifier

tresB — Wed, 29 Mar 2017 13:05:56 GMT

Try like:

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