Skip to main content

Qlik

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: 
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
336 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.
207 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.
207 Views
0 Likes