Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
laxmanqlik
Contributor II

How to do MTD and YTD

Hi Everyone,

i have a requirement that i need to create a MTD and YTD calculation for an organization, i got a sample from the client but have no idea how to achieve it.

i am attaching the the ample Image, please have a look and suggest me a better way to break it.

Thanks in advance..

2 Replies
vinieme12
Esteemed Contributor II

Re: How to do MTD and YTD

Use a Pivot table ,with 3 expressions and drag that dimension over the Expressions

vinieme12
Esteemed Contributor II

Re: How to do MTD and YTD

How to write the expressions you can refer the numerous posts here

https://community.qlik.com/search.jspa?q=MTD&type=document