Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
asknyldz
New Contributor III

Today formula

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

Tags (1)
1 Reply

Re: Today formula

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