Set analysis e() and ignore direct selection

cmorri1988 — Sat, 16 Nov 2024 05:10:25 GMT

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

topic Set analysis e() and ignore direct selection in QlikView

Set analysis e() and ignore direct selection