Set Analysis Question

[#1]

Hi

I'm trying to filter down results on 2 variables, min and max age, and counting number of clients within specified boundaries, and I have looked on similar threads, but my coding does not produce the necessary answer, any ideas?

COUNT({<AGE = {>=$(=vMinAge)<=

$(=vMaxAge)}>} Client)

[MK_QSL · Accepted solution]

COUNT({<AGE = {">=$(=vMinAge)<=$(=vMaxAge)"}>} Client)

or

COUNT({<AGE = {">=$(=vMinAge)<=$(=vMaxAge)"}>} Distinct Client)

[#3]

PFA.

Thanks,

Ram

[its_anandrjs]

COUNT(DISTINT  {<AGE = {">=$(=vMinAge)<= $(=vMaxAge)"}>} Client)

AND

COUNT( {<AGE = {">=$(=vMinAge)<= $(=vMaxAge)"}>} Client)

[VishalWaghole]

Hi Gerhard,

COUNT({<AGE = {">=$(=vMinAge)<=$(=vMaxAge)"}>} Client)

Put set analysis condition into double inverted comma and try if not possible then send your dummy application.

- Regards,

Vishal Waghole

[#6]

Hi all

Thanks for the quick responses, got the required result. Have read through a few topics on set analysis but could not find the correct syntaxes.

Really appreciate your help

Gerhard