Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
narender123
Valued Contributor

Function under expression

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

9 Replies

Re: Function under expression

May be this:

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

migueldelval
Valued Contributor

Re: Function under expression

Try this:


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

Re: Function under expression

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
Valued Contributor

Re: Function under expression

Hello Sunny,

I want to use date function in left side also.

Thanks,

narender123
Valued Contributor

Re: Function under expression

Thanks Kushal,

I want to use date function in left side also.

Thanks,

Re: Function under expression

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

MVP & Luminary
MVP & Luminary

Re: Function under expression

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

- Marcus

Digvijay_Singh
Honored Contributor III

Re: Function under expression

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

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

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