topic Re: Set anslisys: inner functions in QlikView

Set anslisys: inner functions

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

Hi! Need your help!

I got issue with including additional condition in set analysis.

I got 2expressions:

=sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Stat)>=$(v_stat_min)"}>} uk_bex.Stat)

=sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Vacan)>=$(v_vac_min)"}>} uk_bex.Stat)

I need to combine both expressions in one and get in result someting like this:

=sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Stat)>=$(v_stat_min)"},

sum({<uk_bex.urf_code-={''}>} uk_bex.Vacan)>=$(v_vac_min)"}>} uk_bex.Stat)

But it doesn't work.

Re: Set anslisys: inner functions

Anonymous — Wed, 23 Nov 2016 13:44:06 GMT

Try:

=sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Stat)>=$(v_stat_min)"} , uk_bex.urf_code-={''}>} uk_bex.Vacan)>=$(v_vac_min)"}>} uk_bex.Stat>} uk_bex.Stat)

OR adding the two

=sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Stat)>=$(v_stat_min)"}>} uk_bex.Stat)

sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Vacan)>=$(v_vac_min)"}>} uk_bex.Stat)

Re: Set anslisys: inner functions

rubenmarin — Wed, 23 Nov 2016 13:53:30 GMT

Hi, when you say 'combine' is sum both expressions or apply both set analysis in one expression?, in case it's the second one, you can try with:

=sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Stat)>=$(v_stat_min) and sum({<uk_bex.urf_code-={''}>} uk_bex.Vacan)>=$(v_vac_min)"}>}uk_bex.Stat)

or:

=sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Stat)>=$(v_stat_min)"}>

* <uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Vacan)>=$(v_vac_min)"}>}uk_bex.Stat)

Re: Set anslisys: inner functions

aisolomatin — Wed, 23 Nov 2016 14:10:33 GMT

Thank you, Ruben!

First expression works great!