Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
laxmanqlik
Creator II
Creator II
‎2017-05-18 05:33 AM

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..

Preview file
66 KB
873 Views
0 Likes
2 Replies
vinieme12
Champion III
Champion III
‎2017-05-18 05:52 AM

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
744 Views
0 Likes
vinieme12
Champion III
Champion III
‎2017-05-18 05:53 AM

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

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
744 Views
0 Likes