Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to calculate MTD/YTD

Dear All,

    Hope so al doing well.

    I need help for MTD/YTD Calculations,but i need to calculate in back end itself.Because i want to reduce the front end expressions

    is ther any way to do it.

Regards,

Santhosh Kumar G

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: How to calculate MTD/YTD

I have attached one file .Please check helpful for MTD/YTD  Calculation

Regards,

Perumal

View solution in original post

4 Replies
Highlighted
Creator III
Creator III

How to calculate MTD/YTD

Use the below script

Load

If(InYearToDate([Date_Field],today(),0),true(),false()) as YTD,

If(InMonthToDate([Date_Field],today(),0),true(),false()) as MTD

From......

[Date_Field] - Date used in your application.

You can use the YTD or MTD value in Front end like, Sum(SalesAmount*YTD) or Sum(SalesAmount*MTD) which gives you the sum of sales amount for the year till date or month till date respectively...

Highlighted
Partner
Partner

Re: How to calculate MTD/YTD

I have attached one file .Please check helpful for MTD/YTD  Calculation

Regards,

Perumal

View solution in original post

Highlighted
Not applicable

How to calculate MTD/YTD

Thank you Mr.Perumal

Highlighted
Not applicable

Re: Re: How to calculate MTD/YTD

Hi perumal ,

plz find below attachment for ytd