Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
cmorri1988
Creator
Creator

Set analysis e() and ignore direct selection

Hi there,

 

I am currently using the following set analysis expression

 

Let vSetModifier10 = 'ID = p({<CT_KEY =  (p(CT_KEY)),Contributor = e(Contributor)
bisac_sbj2_code = p(bisac_sbj2_code)+p(bisac_sbj3_code),
ID = e(ID),Author = , Title = , ISBN =';

Only({1<$(vSetModifier10)>})>}

//Aggregate each match over each selected ID
Aggr(
rank(RANK(


Only({1<$(vSetModifier10)>})>}

//Aggregate each match over each selected ID
Aggr(
rank(-1*RANK(

(
//Ranked Format Difference
(-1*rank(-1*(fabs(
Sum(TOTAL<CT_KEY> 
Aggr( avg(Binding_Prioritisation),CT_KEY))
-
Only({1<$(vSetModifier10)>})>}(Binding_Prioritisation)))),0,1)
*$(vFormatWeighting))


)

,4,1),4,1)
,CT_KEY,ID)) 

When I use this, and Contributor = e(Contributor) and then select a Contributor value - the expression returns no results.

With no Contributor selection, but selections in other fields such as ISBN, results are returned.

 

Please can I ask how i might get the expression to consider indirect selections for Contributor, but ignore direct selections.

 

Thanks

 

Labels (1)
0 Replies