Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

select latest date in date_field


Hi,

I am sure this is an easy answer.

I have:

dateno. of products
12/11/20132
09/11/20133
12/11/20134
13/10/20136
12/1120138

I want to use set analysis to tell me the count of products when the date sold is the latest date (i.e. date =12/11/2013)

how do I write this expression?

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: select latest date in date_field

try something like

=sum({<date = {'$(=date(max(date)))'}>} [no. of products])

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: select latest date in date_field

try something like

=sum({<date = {'$(=date(max(date)))'}>} [no. of products])

View solution in original post

Highlighted
Not applicable

Re: select latest date in date_field

Hi,

try this and let me know.

Count({$<Date={"=$(=date(max(Date)))"}>}NoOfProducts)

Regards,

Ashutosh