topic to pass a selected value from field into formula in QlikView

to pass a selected value from field into formula

Mon, 21 Feb 2011 22:03:06 GMT

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,

to pass a selected value from field into formula

Mon, 21 Feb 2011 22:20:17 GMT

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)

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

Hope this helps

Regards!

to pass a selected value from field into formula

Mon, 21 Feb 2011 22:30:39 GMT

Hi Gabriela,

it did not work But thank you for help

to pass a selected value from field into formula

Mon, 21 Feb 2011 22:47:13 GMT

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

looks like that function should help you out.

Chris

to pass a selected value from field into formula

Mon, 21 Feb 2011 23:03:21 GMT

Hi Chris,

do you mean in that way:

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

This wont work too

Regards,

to pass a selected value from field into formula

Mon, 21 Feb 2011 23:13:37 GMT

does the following statement work:

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

If not, please attach an example file.

Chris

to pass a selected value from field into formula

rbecher — Mon, 21 Feb 2011 23:32:36 GMT

Onur,

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

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

- Ralf

to pass a selected value from field into formula

Mon, 21 Feb 2011 23:36:29 GMT

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.

to pass a selected value from field into formula

Mon, 21 Feb 2011 23:41:29 GMT

Hi Ralf,

hmmm, unfortunately with no effect to the textfiled.

Best Regards,
Onur

to pass a selected value from field into formula

rbecher — Mon, 21 Feb 2011 23:53:33 GMT

..this should go (with no quotes):

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

- Ralf

to pass a selected value from field into formula

llauses243 — Tue, 22 Feb 2011 02:15:51 GMT

Hi honour74,

This is my offer (see expression in image)

Good luck, Luis