Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have dataset month from 2/1/2021 - 2/1/2022.
if i wrote down below:
=sum(if([CPR_TM1_202202.MONTH]>= addmonths(Max(total [CPR_TM1_202202.MONTH]),-2) and [CPR_TM1_202202.Business]='CMB', [CPR_TM1_202202.amount]/1000000000/2))
it will get the sum amount from max date (2/1/2022) to (1/1/2022).
but it's still static. i need to change every month "-2" with another value to get sum current amount.
any idea how to make it dynamic?
Thank you
Regards,
Daniel
Dear Daniel,
i think you could use: https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Measures/modifiers.h...
But maybe i did not get your question right..