Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I am based on the following selections:
using this measure:
only({1<ID = p({<CT_KEY = (P(CT_KEY)), bisac_sbj1_code = (p(bisac_sbj1_code)), bisac_sbj2_code = (p(bisac_sbj2_code)), bisac_sbj3_code = (p(bisac_sbj3_code)), [Price] = {">=$(vMinCTPrice)<=$(vMaxCTPrice)"}, [Pub Date Num] = {">=$(vMinCTPubDate)<=$(vMaxCTPubDate)"}, ID = e(ID),Author = , Title =, ISBN = >})>} //Aggregate each match over each selected ID and CTKEY Aggr( only({1<ID = p({<CT_KEY = (P(CT_KEY)), bisac_sbj1_code = (p(bisac_sbj1_code)), bisac_sbj2_code = (p(bisac_sbj2_code)), bisac_sbj3_code = (p(bisac_sbj3_code)), [Price] = {">=$(vMinCTPrice)<=$(vMaxCTPrice)"}, [Pub Date Num] = {">=$(vMinCTPubDate)<=$(vMaxCTPubDate)"}, ID = e(ID),Author = , Title =, ISBN = >})>} Rank6) ,CT_KEY, ID))
the problem I am having is the results are using possible bisac_sbj2_code values for any selection, and not those related to each ID and CTKEY.
From the results, bisac_sbj2_code is blank, but from the selection ISBN 9780007382767, bisac_sbj2_code is OCCO19000, and so I would like these results to have this code, being aggregated for each selected CTKEY and ID.
Any help most welcome!
Thanks!
FYI,
I managed to get this to work by creating the following within the script,
CT_KEY&bisac_sbj2_code as bsc2_test, CT_KEY&bisac_sbj3_code as bsc3_test,
and changing the measure to:
only({1<ID = p({<CT_KEY = (P(CT_KEY)), [BISAC Subject Code] = (p([BISAC Subject Code])), bisac_sbj2_code = (p(bisac_sbj2_code)), bisac_sbj3_code = (p(bisac_sbj3_code)), ID = e(ID), Title =, ISBN = >})>} //Aggregate each match over each selected ID and CTKEY Aggr( only({1<ID = p({<CT_KEY = (P(CT_KEY)), [BISAC Subject Code] = (p([BISAC Subject Code])), bsc2_test = (p(bsc2_test)), bsc3_test = (p(bsc3_test)), ID = e(ID), Title =, ISBN = >})>} ID) ,CT_KEY, ID))
Thanks