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: 
farzeenabbas
Contributor II
Contributor II

Qlik frontend

Hi everyone, l have to calculate sum of a field for today date how can i do this ? please answer.

Labels (1)
3 Replies
salonicdk28
Creator II
Creator II

Can you please help with the sample data and the actual requirement

Thanks,

Saloni

farzeenabbas
Contributor II
Contributor II
Author

this is a sample expression in which i am counting the sum of a field for today's date i want the same value   'sum({<Date = {'$(=Date(today()))'} >} [field])' but without using today function if the today's value is null it shows the previous day value this is what i actually want.  

Anku
Creator
Creator

@farzeenabbas  Try sum({<Date={'$(Max(Date))'}>} [field])