topic Today formula in QlikView

Today formula

asknyldz — Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

I want to today date in my formula instead of 01/05/2016

(sum({<TYPE={'ACTUAL'},BUSINESS={'NEW','EXPANDED'}*P([BUSINESS]),MONTH={'<=01/05/2016'}*P(MONTH)>-<CLIENT={'NEW CLIENTS','EXPANDED CLIENTS','FORECAST ADJUSTMENT'}>}AMOUNT))/1000

Thank you

Re: Today formula

sunny_talwar — Wed, 11 May 2016 15:02:53 GMT

I hope that MONTH field is actually a date field, else this is not going to work. If it isn't use a date field here

(Sum({<TYPE={'ACTUAL'},BUSINESS={'NEW','EXPANDED'}*P([BUSINESS]), DATE={"<=$(=Today(), 'DD/MM/YYYY')"}*P(MONTH)>-<CLIENT = {'NEW CLIENTS', 'EXPANDED CLIENTS', 'FORECAST ADJUSTMENT'}>}AMOUNT))/1000