Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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