Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
arusiva89
Contributor III
Contributor III

Month over month

Hi All,

   I need a clarification for month over month calculation,I have implemented  it something like creating two variables ( Current Month & Previous Month) and set expression to handle the calculation.It is working fine but When I select Apr - 2020 (30 days) compared with March (30 days) and it results in percentage variation for MOM% ,Any way to rectify that.I want to compare March 31 days vs April 30 days.I cannot aggregate the data at month level( Date is lowest granularity )

0 Replies