Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
ilanbaruch
Contributor III

set analysis with GetFieldSelections

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) 

1 Solution

Accepted Solutions

Re: set analysis with GetFieldSelections

Hi,

maybe another solution could be:

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

or

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

to avoid an "error in expression":

QlikCommunity_Thread_231456_Pic4.JPG

QlikCommunity_Thread_231456_Pic5.JPG

QlikCommunity_Thread_231456_Pic1.JPG

QlikCommunity_Thread_231456_Pic2.JPG

QlikCommunity_Thread_231456_Pic3.JPG

hope this helps

regards

Marco

View solution in original post

5 Replies

Re: set analysis with GetFieldSelections

Try this instead:

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

Re: set analysis with GetFieldSelections

Or this if you really want to use GetFieldSelections

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

Re: set analysis with GetFieldSelections

Hi,

maybe another solution could be:

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

or

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

to avoid an "error in expression":

QlikCommunity_Thread_231456_Pic4.JPG

QlikCommunity_Thread_231456_Pic5.JPG

QlikCommunity_Thread_231456_Pic1.JPG

QlikCommunity_Thread_231456_Pic2.JPG

QlikCommunity_Thread_231456_Pic3.JPG

hope this helps

regards

Marco

View solution in original post

ilanbaruch
Contributor III

Re: set analysis with GetFieldSelections

it helps,thank you!

rubandoss786
Contributor

Re: set analysis with GetFieldSelections

Hi ilan,

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