to pass a selected value from field into formula

[#1]

Hi Qlikview Community,

how can i put the selected value from field to pass in to my formula ? [*-)] Please see screenshot !

Thank you very much [8-|]

Best Regards,

[#2]

Hi,

You can just include the file name or use it with another function like Only() or Max(), so you have something like this:

sum({1<[YEAR]={'$([YEAR])''}>} TotalPrice)

or

sum({1<[YEAR]={'$(max([YEAR]))''}>} TotalPrice)

Hope this helps

Regards!

[#3]

Hi Gabriela,

it did not work But thank you for help

[#4]

the expression: GetFieldSelections( fieldname) returns a string containing the current selections in a given field.

looks like that function should help you out.

Chris

[#5]

Hi Chris,

do you mean in that way:

=sum ({1< [YEAR] = { GetFieldSelections( [YEAR] ) } >} TotalPrice ) ?

This wont work too

Regards,

[#6]

does the following statement work:

=sum ({1< [YEAR] = {'$(=GetFieldSelections(" [YEAR]" ) '} >} TotalPrice )

If not, please attach an example file.

Chris

[rbecher]

Onur,

your field name is a bit confusing... try this:

=sum ({1< [HEL_DATA_Datum > Year] = { GetFieldSelections( [HEL_DATA_Datum > Year] } >} TotalPrice )

- Ralf

[#8]

Hi Chris,

thank you for helping me. Unfortunately it didnt work again. Here are my qvw file. It is the Textfield under the textfield "Total Price PLAN".

Thank you again.

[#9]

Hi Ralf,

hmmm, unfortunately with no effect to the textfiled.

Best Regards,
Onur

[rbecher · Accepted solution]

..this should go (with no quotes):

= 'Totalprice (TOTAL) PLAN: ' & sum ({1< [HEL_DATA_Datum > YEAR] = {$(=GetFieldSelections([HEL_DATA_Datum > YEAR]))} >} SAL_OPPORTUNITYLINEITEM_TotalPrice )

- Ralf