topic Re: Calculation of MTD and YTD in QlikView

Calculation of MTD and YTD

priyav24 — Wed, 03 Jul 2013 07:41:26 GMT

Hello Everybody!!

I need Calculation for MTD & YTD..

Thank in Advance,

Priya

Re: Calculation of MTD and YTD

Sokkorn — Wed, 03 Jul 2013 07:50:28 GMT

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

Re: Calculation of MTD and YTD

kaushiknsolanki — Wed, 03 Jul 2013 07:52:08 GMT

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

Re: Calculation of MTD and YTD

Anonymous — Wed, 03 Jul 2013 07:57:42 GMT

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

Re: Calculation of MTD and YTD

priyav24 — Wed, 03 Jul 2013 08:40:57 GMT

Thank you Kaushik

Re: Calculation of MTD and YTD

priyav24 — Wed, 03 Jul 2013 08:41:19 GMT

Thanks Shivaji