Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

try something like

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

View solution in original post

2 Replies
swuehl
MVP
MVP

try something like

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

View solution in original post

Not applicable
Author

Hi,

try this and let me know.

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

Regards,

Ashutosh