topic Re: set analysis with GetFieldSelections in QlikView

set analysis with GetFieldSelections

ilanbaruch — Sun, 04 Sep 2016 10:19:24 GMT

Hi All,

i want to create an expression with set analysis based on another field / dimension selection?

any ideas ?

tried it like this:

sum({$<Office={GetFieldSelections(OFFICE_BUDGET)}> } amount)

sunny_talwar — Sun, 04 Sep 2016 10:26:06 GMT

Try this instead:

Sum({$<Office = P(OFFICE_BUDGET)>} amount)

sunny_talwar — Sun, 04 Sep 2016 10:28:36 GMT

Or this if you really want to use GetFieldSelections

Sum({$<Office = {$(=Chr(39) & GetFieldSelections(OFFICE_BUDGET,Chr(39) & ',' & Chr(39)) & Chr(39))}>} amount)

MarcoWedel — Sun, 04 Sep 2016 21:51:17 GMT

Hi,

maybe another solution could be:

Sum({$<Office=OFFICE_BUDGET>} amount)

Sum({$<Office=$::OFFICE_BUDGET>} amount)

to avoid an "error in expression":

hope this helps

regards

Marco

ilanbaruch — Wed, 07 Sep 2016 08:59:11 GMT

it helps,thank you!

Anonymous — Sat, 29 Apr 2017 19:25:41 GMT

Hi ilan,

It is working fine, but what is the actual usage of $::. Thanks in advance...