sum modifier in combination with aggr

[#1]

Hi Qlkview Community,

I want to make the text field independent from any selection.
Excluding the year field. I would therefore like to expand the field around this behavior.

I want ti use somethink like this

{1 <[HEL_DATA_Datum> YEAR] = {$ (GetFieldSelections = ([HEL_DATA_Datum> YEAR]))}>}


here the code I tried to modify:

#######################################

=sum( {1 <[HEL_DATA_Datum> YEAR] = {$ (GetFieldSelections = ([HEL_DATA_Datum> YEAR]))}>} Aggr(

if( index(concat([HEL_BANNER_Banner]),'lock')>=1,
(sum([HEL_DATA_Imps mit Defaults])*0.5),(sum([HEL_DATA_Imps mit Defaults])) ) *
SAL_OPPORTUNITYLINEITEM_UnitPrice

,SAL_OPPORTUNITY_Name, SAL_PRODUCT_Name))

########################################

But unfortunately without success.

Perhaps you have an idea?

Thank you for any help

Best Regards,

[#2]

here my QVW file for better visualization

Thank you !

[#3]

Hi,

did you try this

=sum({1<[HEL_DATA_Datum > YEAR]={"$(=Max([HEL_DATA_Datum > YEAR]))"}>} aggr(

if(index(concat([HEL_BANNER_Banner]),'lock')>=1,

sum({1<[HEL_DATA_Datum > YEAR]={"$(=Max([HEL_DATA_Datum > YEAR]))"}>} [HEL_DATA_Imps mit Defaults])*sum({1<[HEL_DATA_Datum > YEAR]={"$(=Max([HEL_DATA_Datum > YEAR]))"}>} SAL_OPPORTUNITYLINEITEM_UnitPrice)*0.5,

(sum({1<[HEL_DATA_Datum > YEAR]={"$(=Max([HEL_DATA_Datum > YEAR]))"}>} [HEL_DATA_Imps mit Defaults])*sum({1<[HEL_DATA_Datum > YEAR]={"$(=Max([HEL_DATA_Datum > YEAR]))"}>} SAL_OPPORTUNITYLINEITEM_UnitPrice)))

,SAL_PRODUCT_Name))

regards,

[#4]

Hi,

this is not what i am looking for. But thanks for your help.

Could you look at my qvw file? I have a formula that actually works quite well, but I would like to have the other selections have no effect on this formula. Exception is the year field.

Please help

Thank you!

[#5]

Hi Qlikview Community,

i need urgent help. Can somebody help me with my problem?
Thank you!

Best regards,

[#6]

This problem is apparently not directly solvable in Qlikview. Workarounds solved using Macro

If anyone needs a tip, just say