topic Re: select latest date in date_field in QlikView

select latest date in date_field

Thu, 21 Nov 2013 13:59:27 GMT

Hi,

I am sure this is an easy answer.

I have:

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?

swuehl — Thu, 21 Nov 2013 14:06:18 GMT

try something like

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

Thu, 21 Nov 2013 14:06:38 GMT

Hi,

try this and let me know.

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

Regards,

Ashutosh