topic Re: Set Analysis \ addmonths in QlikView

Set Analysis \ addmonths

ilanbaruch — Mon, 21 May 2018 06:53:40 GMT

hi all

trying to calculate previous three months from user selection i.e

if the user selected 201804 the expression should retrieve calculation for : 201804,201803,201802

tried it with :

SUM({<YYYYMM={"$(='>=' & date(AddMonths(max(FULL_DATE),-3),'YYYYMM'))"},MM=,YYYY=>}AMOUNT)

but it retrieves 0 , (not the actual result)

any ideas?

advanced thanks

arvind_patil — Mon, 21 May 2018 07:08:43 GMT

Hi ilan,

Please try below highlighted :

SUM({<YYYYMM={"$(='<=' & date(AddMonths(max(FULL_DATE)),'YYYYMM'))"},MM=,YYYY=>}AMOUNT)

YYYYMM={"<=$(=AddMonths(Max(YYYYMM)))>=$(=AddMonths(Max(YYYYMM),-3))"}

Thanks,

Arvind Patil

ilanbaruch — Mon, 21 May 2018 07:36:37 GMT

thank you very much,

below my final expression :

YYYYMM={"<=$(=AddMonths(Max(YYYYMM),0))>=$(=AddMonths(Max(YYYYMM),-3))"}

arvind_patil — Thu, 07 Jun 2018 12:13:33 GMT

Welcome

Thanks,

Arvind Patil