topic sum modifier in combination with aggr in QlikView

sum modifier in combination with aggr

Wed, 23 Feb 2011 19:28:36 GMT

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,

sum modifier in combination with aggr

Wed, 23 Feb 2011 19:31:31 GMT

here my QVW file for better visualization

Thank you !

sum modifier in combination with aggr

Wed, 23 Feb 2011 21:04:41 GMT

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,

sum modifier in combination with aggr

Wed, 23 Feb 2011 21:24:18 GMT

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!

sum modifier in combination with aggr

Thu, 24 Feb 2011 10:57:38 GMT

Hi Qlikview Community,

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

Best regards,

sum modifier in combination with aggr

Fri, 25 Feb 2011 15:05:58 GMT

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

If anyone needs a tip, just say