Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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!