Stuck with set expression

[peterstalberg]

Hi guys,

I'm really scratching my head on this one. Can anybody please explain to me why set expression A. works fine whereas set expression B. gives me an error ( ',' or ')' expected?

A. 

{<[Claim ref]={"=aggr(rank(avg({< [Claim now 100% USD]={'10000'} >} [Claim ref]))) <=$(v_#LATEST_CLAIMS)"}>}

B.

{<[Claim ref]={"=aggr(rank(avg({< [Claim now 100% USD]={">10000"} >} [Claim ref]))) <=$(v_#LATEST_CLAIMS)"}>}

RGDS//Peter

[Anil_Babu_Samineni]

@peterstalberg the fact could be you don't have any records that is >10000, Instead In case you need that is with 10000, Perhaps this try with >=10000

[theoat]

Have you tried this ?
{<[Réf. de réclamation]={"=aggr(rank(avg({< [Réclamez maintenant 100 % USD]>10000 >} [Réf. réclamation]))) <=$(v_#LATEST_CLAIMS)"}>}

[David_Friend]

Try comparing them using Notepad++ with the 'compare' plug-in to look for differences

also what version of QS is this on.

[peterstalberg · Accepted solution]

Hi,

The only difference between A. & B. is {'10000'} vs {">10000"}, changing from a fixed value to a search string.

@Anil_Babu_Samineni there is data available.

@theoat not giving the expected result.

Nevertheless, I solved this by using an "if" statement instead. RGDS//Peter

If(
aggr( rank(avg({< [Claim now 100% USD]={">=$(v_CLAIM_AMOUNT_LIMIT)"} >} [Claim ref])), [Claim handler])<=$(v_#LATEST_CLAIMS),
......