topic Re: info requested expression in QlikView

info requested expression

Wed, 25 Nov 2020 16:16:04 GMT

All, I am stuck with below expression

instead of Field name in sum function I need to resolve field as below, can someone provide solution to it.

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)))

Re: info requested expression

Anil_Babu_Samineni — Fri, 02 Dec 2016 00:09:16 GMT

You may post full expression. I mean to say with Variable / What were these? eAmt & eAmount & %Country

Re: info requested expression

Fri, 02 Dec 2016 01:19:01 GMT

please help finding issue here....

where VABDate is variable with format 02/12/2016

Sum( {$ <[A Date]={">=$(=date (MonthStart(Max(A Date]) ),'dd/mm/yyyy'))<= date('$(vABDate)','DD/MM/YYYY') "} >} XXX )

Re: info requested expression

Anil_Babu_Samineni — Fri, 02 Dec 2016 01:40:02 GMT

Try with this

Sum( {$ <[A Date]={">=$(=date (MonthStart(Max(A Date]) ),'dd/mm/yyyy'))<= MakeDate('02/12/2016') "} >} XXX )

Re: info requested expression

hemanthaanichet — Fri, 02 Dec 2016 05:32:50 GMT

Hi Rajesh

U may try the below expression:

Sum( {$ <[A Date]={">=$(=Date (MonthStart(Max(A Date]) ),'DD/MM/YYYY')) <= Date('Today()',DD/MM/YYYY) "} >} XXX )

Regards

Hemanth

Re: info requested expression

Tue, 06 Dec 2016 08:14:15 GMT

All,

I need some help on resolving an expression ...

This is working fine...Sum( {$ < [A Date]={">=$(vMonthStart) <=$[A Date]"} >} [#AMT] )

However want to redefine and make it parameterised

step1:-

defined function

eAmt=Sum({$<$(vCommonFilter),)>}[#AMT])

step 2:-

trying to resolve

($($(=eAmt), $(=[A Date]={">=$(vMonthStart) <=$[A Date]"}) )

basically I am trying to pass date condition( [A Date]={">=$(vMonthStart) <=$[A Date]"}) to the sum function at run time. I am getting null value as output

Thanks in advance!