https://community.qlik.com/t5/App-Development/Set-YTD-amp-MTD-in-analysis/m-p/2081569#M88704 <P>Hi, All,</P> <P>The formulas of month in my application is as below.</P> <P>Month(Makedate(2000,Num#(period,'0'))) as Month</P> <P>And my YTD &amp; MTD formulas is set up like this. However it only works for YTD formulas. It always shows 0 in MTD.</P> <P>Sum({&lt;[Calendar Year]={$(=Maxstring([Calendar Year]))}&gt;}[Net Sales $])</P> <P>Sum({&lt;[Calendar Year]={$(=Maxstring([Calendar Year]))},Month={$(=MaxString(Month))}&gt;}[Net Sales $])</P> <P>Do you have any idea that if my MTD formulas is not working? Thanks a lot.</P> Thu, 08 Jun 2023 10:13:39 GMT Cassie_L 2023-06-08T10:13:39Z https://community.qlik.com/t5/App-Development/Set-YTD-amp-MTD-in-analysis/m-p/2081569#M88704 <P>Hi, All,</P> <P>The formulas of month in my application is as below.</P> <P>Month(Makedate(2000,Num#(period,'0'))) as Month</P> <P>And my YTD &amp; MTD formulas is set up like this. However it only works for YTD formulas. It always shows 0 in MTD.</P> <P>Sum({&lt;[Calendar Year]={$(=Maxstring([Calendar Year]))}&gt;}[Net Sales $])</P> <P>Sum({&lt;[Calendar Year]={$(=Maxstring([Calendar Year]))},Month={$(=MaxString(Month))}&gt;}[Net Sales $])</P> <P>Do you have any idea that if my MTD formulas is not working? Thanks a lot.</P> Thu, 08 Jun 2023 10:13:39 GMT https://community.qlik.com/t5/App-Development/Set-YTD-amp-MTD-in-analysis/m-p/2081569#M88704 Cassie_L 2023-06-08T10:13:39Z