Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
dinicholls
Creator II
Creator II

Set Identifier

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

2 Replies
sunny_talwar

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

tresesco
MVP
MVP

Try like:

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