topic Re: question on count in set analysis expression in QlikView

question on count in set analysis expression

gerrycastellino — Fri, 06 May 2016 00:55:50 GMT

I need to structure an expression where I'm counting all distinct 'A' based on 'B' being not null, for the entire data set:

Count( DISTINCT { < B = {"*"}>} {1} A)

just wanted to confirm if this will work ...

Gerry

sunny_talwar — Fri, 06 May 2016 00:57:56 GMT

Not sure about this hanging {1}, but this should work:

Count(DISTINCT {<B = {'*'}>} A)

or if you want to ignore any selection, then a 1 like this:

Count(DISTINCT {1<B = {'*'}>} A)