Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

if date not selected add todays date

Hi,

I cant seem to find the syntax error in the formula below but i would also like to add "If this is not populated I want the date to chose the current date".

how can I add this to the following syntax please.

So if the 'AsAtDate' is populated the date is taken from this but if left empty the data is taken from today.

SUM( {$<%Date<={AsAtDate}, RecordType= {'WebTraffic'}, Area= {'SR'} >} Sessions ) 

11 Replies
sunny_talwar

Thanks Laura!! I am assuming you are congratulating me for 100k points

Anonymous
Not applicable
Author

yes.  I think your great!