Function under expression

[narender123]

Hi Team,

Ca anyone tell me how to use any function in expression.Suppose expression in straight table like:

=sum({<Date(EnterDate,'MM/DD/YYYY')={'01/01/2015'}>}Amount)

or

=sum({<Date=Date(EnterDate,'MM/DD/YYYY')>}Amount)

or you can take any other function rather than date .

Thanks,

Narender

[sunny_talwar]

May be this:

=Sum({<Date = {"$(=Date(Max(EnterDate),'MM/DD/YYYY'))>} Amount)

[migueldelval]

Try this:

=sum({<Date={"Date(EnterDate,'MM/DD/YYYY')"}>}Amount)

[Kushal_Chawda]

Create Variable in front end vEnterDate

Create input box and enter the date in 'MM/DD/YYYY'

then use expression

Sum({<Date ={"$(=vEnterDate)"}>}Amount)

[narender123]

Hello Sunny,

I want to use date function in left side also.

Thanks,

[narender123]

Thanks Kushal,

I want to use date function in left side also.

Thanks,

[sunny_talwar]

QlikView or QlikSense doesn't allow for functions on the left. Whatever manipulations are needed, do them in the script and then use a manipulated field (from script) in your set analysis

[marcus_sommer]

It's quite similar to these topic: Using Year function in set analysis

- Marcus

[Digvijay_Singh]

Not possible, also normally you don't need to modify left side date, because QV as many options to format the right side value to make it compatible with left one.

[Kushal_Chawda]

Set analysis doesn't allow this, you need to use if for that

Sum(if( Date(Date) = date(EnterDate,'MM/DD/YYYY'), Amount))