need help on qlikview expression

[#1]

Hi All, while writing expression Sum( {$ <[A Date]={">=MonthStart(Max([A Date]) <='29/11/2016' "} >}  $($(='eAmt' )) )  . I am getting 2 issues,

1) Above expression is not getting resolved. however both  Sum( {$ <[A Date]={">=MonthStart(Max([A Date]) <='29/11/2016' "} >}  XXXXX) and  $($(='eAmt' )) is getting resolved separately

2)  Above mentioned A Date is a select from Multi box properties. could you suggest me how I can replace above hardcoded value '29/11/2016' with List box selection A Date.

Thanks in advance !

[vinieme12]

Sum( {$ <[A Date]={">=$(=date (MonthStart(Max([A Date]) ),'dd/mm/yyyy'))<='29/11/2016' "} >}  $($(='eAmt' )) )

[Anonymous]

Hey,

you can use getfileddelection () function for 2nd problem.

Thanks,

[Anil_Babu_Samineni]

What was the eAmt here. Does this simple field name? I mena have you created Variable name for Field / What?

[HirisH_V7]

Hi,

Check this,

1.

  Sum( {$ <[A Date]={'>=$(=MonthStart(Max([A Date]))) <=29/11/2016'} >}  $($(='eAmt' )) )

2.

 Sum( {$ <[A Date]={'>=$(=MonthStart(Max([A Date]))) <=$(=GetFieldselections([A Date]))'} >}  $($(='eAmt' )) )

Regards,

Hirish

[#6]

Thanks

[#7]

got stuck with another expression, please provide your input.

during sum calculation... instead of field name I have expression to resolve into field name, not sure if I can do  both in  single go. can you please share how it can be achieved.

Sum( {$ <[A Date]={">=MonthStart(Max([A Date]) <='29/11/2016' "} >}  $($(='eAmt' )) expression)

example -Sum( {$ <[A Date]={">=MonthStart(Max([A Date]) <='29/11/2016' "} >}  $($(='eAmt' )) $($(='eAmount' & %Country)))

[HirisH_V7]

Hi,

Can you please elaborate your requirement,

You want to calculate sum(Amount) and that to between certain dates.Till there its fine and you want to include or exclude  particular country What!.

Make a small example kind off app.If possible.

-Hirish

[#9]

Hi All,

need your help to resolve below issue

variable defined
vft=placeholder
eSumAmt=Sum({$<$(vft)>} AMT)
TT='[A Date]={">=$(vMonthStart) <=$(A Date)"}'

want to override at object level
vft=$(TT)

to calculate
($($(='eSumAmt'),$(TT)  ) )

Current issue
getting out put as null, it seems there is issue with to calculate syntax