Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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