topic Set Analysis Question in QlikView

Set Analysis Question

Wed, 02 Apr 2014 06:01:30 GMT

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)

Re: Set Analysis Question

MK_QSL — Wed, 02 Apr 2014 06:03:12 GMT

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

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

Re: Set Analysis Question

Wed, 02 Apr 2014 06:06:09 GMT

PFA.

Thanks,

Ram

Re: Set Analysis Question

its_anandrjs — Wed, 02 Apr 2014 06:06:32 GMT

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

AND

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

Re: Set Analysis Question

VishalWaghole — Wed, 02 Apr 2014 06:08:56 GMT

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

Re: Set Analysis Question

Wed, 02 Apr 2014 06:17:35 GMT

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