topic Re: Function under expression in QlikView

Function under expression

narender123 — Wed, 01 Jun 2016 10:37:13 GMT

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)

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

or you can take any other function rather than date .

Thanks,

Narender

Re: Function under expression

sunny_talwar — Wed, 01 Jun 2016 10:38:57 GMT

May be this:

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

Re: Function under expression

migueldelval — Wed, 01 Jun 2016 10:39:07 GMT

Try this:

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

Re: Function under expression

Kushal_Chawda — Wed, 01 Jun 2016 10:40:14 GMT

Create Variable in front end vEnterDate

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

then use expression

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

Re: Function under expression

narender123 — Wed, 01 Jun 2016 10:44:41 GMT

Hello Sunny,

I want to use date function in left side also.

Thanks,

Re: Function under expression

narender123 — Wed, 01 Jun 2016 10:45:36 GMT

Thanks Kushal,

I want to use date function in left side also.

Thanks,

Re: Function under expression

sunny_talwar — Wed, 01 Jun 2016 10:46:14 GMT

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

Re: Function under expression

marcus_sommer — Wed, 01 Jun 2016 10:48:58 GMT

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

- Marcus

Re: Function under expression

Digvijay_Singh — Wed, 01 Jun 2016 10:50:59 GMT

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.

Re: Function under expression

Kushal_Chawda — Wed, 01 Jun 2016 10:51:28 GMT

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

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