Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

MTD Charts

Hi,

My requirement is to create MTD (Month to Date) charts based on the user selection of date. if the user select any date of the month Chart should display Actual and Plan information form start of the month to selected Date. For example if user selects 23/11/2014, then chart should display Actula and plan data form 1/11/2014 to 23/11/2014.

Can any one please advise me on the date expression in Chart. I have date in the format of DD/MM/YYYY.

Best Regards,

1 Solution

Accepted Solutions
jonasheisterkam
Contributor III

Re: MTD Charts

Sum({< Date= {">=$(=Date(monthstart(max(Date)))<=$(=Date(max(Date))"} >} Value)

2 Replies
jonasheisterkam
Contributor III

Re: MTD Charts

Sum({< Date= {">=$(=Date(monthstart(max(Date)))<=$(=Date(max(Date))"} >} Value)

Not applicable

Re: MTD Charts

Thanks Jonas,

The formula worked.

Regards.

Sandhya Molli

Community Browser