topic Exclude Selection in expression without Set Analysis? in QlikView

Exclude Selection in expression without Set Analysis?

Sean-CPT — Thu, 08 Aug 2019 10:36:13 GMT

Hi Everyone,

So the problem I have is I've got the below statement working as is and I haven't been able to convert it using Set Analysis.

sum(If(GROUP_MONTH = REGISTRATION_MONTH and GROUP_MONTH >= vSixMonthsBack and Type = 'Joiners',
MEMBERS_JOINING))

variable: vSixMonthsBack = '201902'

I have a field COUNTRY that I basically want to ignore in the above expression. In Set Analysis I would've used {$<COUNTRY=>} .

Any advice on how to change this would be appreciated?

tresB — Thu, 08 Aug 2019 10:51:41 GMT

Try like:

sum({$<COUNTRY=>} If(GROUP_MONTH = REGISTRATION_MONTH and GROUP_MONTH >= vSixMonthsBack and Type = 'Joiners',
MEMBERS_JOINING))

Also, if your variable definition has any aggregation function, try to use the same set analysis in that too like:

vSixMonthsBack= Max( {$<COUNTRY=>} DateField.....)

Sean-CPT — Thu, 08 Aug 2019 11:48:30 GMT

Hi Tresesco,

That worked precisely as I wanted it too, thanks for the help!