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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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])