Calculation of MTD and YTD

[priyav24]

Hello Everybody!!

I need Calculation for MTD & YTD..

Thank in Advance,

Priya

[Sokkorn]

Hi Priya,

Your requirement is not so clear while we don't have sample App or data that you looking for. Anyhow, here is some idea to get start.

Regards,

Sokkorn

[kaushiknsolanki]

Hi,

     Have a look at the link

     http://community.qlik.com/docs/DOC-4321

     Have a look at the point in time application on below post.

     http://community.qlik.com/thread/32479

Regards,

Kaushik Solanki    

[Anonymous · Accepted solution]

Hi priya

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. To help full this answer

[priyav24]

Thank you Kaushik

[priyav24]

Thanks Shivaji