Nested Set Analysis with conditions

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I need to create a nested set analysis with the following nested If statement, would appreciate any help or ideas.

=If([PROVIDER]='ABC' OR 'XYZ' AND [CODE] like '7*','NO',

If([FSC]=61,'NO',

If ([LOC]='HSP' AND([C_DT]-[S_DT])>3, 'YES',

If([LOC]='DLS' AND([C_DT]-[S_DT])>45,'YES',

'NO'))))

Re: Nested Set Analysis with conditions

sunny_talwar — Wed, 19 Oct 2016 17:05:56 GMT

Why don't you make the change in the script to create a new field with YES and NO values? AFAIK, I think this expression is not the best place to use set analysis.

topic Re: Nested Set Analysis with conditions in QlikView

Nested Set Analysis with conditions

Re: Nested Set Analysis with conditions