topic Maxdate parameter in expression in QlikView

Maxdate parameter in expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

This one is going to come off as pretty dumb, but I'm forgetting something or skipping something simple in my expression.

All I want is the count of IDs, with the maxDate as the expression. But I'm not sure how to set up that expression with the function in it, and finding proper syntax within the community is far from easy.

So imagine the regular count of IDs:

=count(distinct ID)

I'd like the count to be for the maxDate only, either using a variable set to max(theDate) or the function within the expression itself, something like:

=count({<theDate = max(theDate)>} distinct ID)

this syntax is wrong, I know, but I'm not sure what to add/take away to make it function properly. Any help?

Thanks

Re: Maxdate parameter in expression

its_anandrjs — Thu, 24 Aug 2017 13:39:42 GMT

Try to write

=count( { < theDate = {$(=max(theDate) ) } >} distinct ID)

Re: Maxdate parameter in expression

its_anandrjs — Thu, 24 Aug 2017 13:43:59 GMT

Actually try this

=count( { < theDate = {'$(=Date(max( theDate )) )' } >} Distinct Doc_name)

=count( { < theDate = {'$(=Date(max( theDate )) )' } >} Doc_name)

=count( { < theDate = {$(=max(theDate) ) } >} distinct Doc_name)

Re: Maxdate parameter in expression

Anonymous — Thu, 24 Aug 2017 14:02:38 GMT

I'm getting 0 as the result, I've attach the simplified qlik to my original and maybe you can write the expression until it works?

I have inline loaded the dates as exactly the dates numbers... so they may need to be reformatted I suppose. Perhaps that's an issue as well. Sorry

Creating the maxDate as a variable and using that would also be totally fine.

Re: Maxdate parameter in expression

sunny_talwar — Thu, 24 Aug 2017 14:06:38 GMT

May be this

=count({<theDate = {"$(=Date(Max(theDate), 'YYYY-MM-DD'))"}>} distinct ID)

Re: Maxdate parameter in expression

Anonymous — Thu, 24 Aug 2017 14:10:54 GMT

nailed it, thanks Sunny!

Re: Maxdate parameter in expression

its_anandrjs — Thu, 24 Aug 2017 14:11:57 GMT

Ok it is date format issue

Try and see attached also

=count({< theDate = { '$(=max(theDate))' }>} distinct ID)

Re: Maxdate parameter in expression

its_anandrjs — Thu, 24 Aug 2017 14:12:59 GMT

Did you check my reply as well.