Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lauracastagna
Creator II
Creator II

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

lauracastagna
Creator II
Creator II
Author

yes.  I think your great!