Last sale date (set analyses)

[Sergey1]

Hi 

I try to got last sales date:

=Max({$<[SalesQuantity]={'>0'}>}TransDate) - Doesn't work

=Max({$<[SalesQuantity]={'=0'}>}TransDate) - Doesn't work

=Max({$<[SalesQuantity]={0}>}TransDate) - Work fine, but 

 How to get the maximum date where SalesQuantity> 0 

[Thiago_Justen_]

Try this out:

Max({$<[SalesQuantity]={">0"}>}TransDate)

[Sergey1]

I tried Max({$<[SalesQuantity]={">0"}>}TransDate)

But it doesn't work 

[Frank_Hartmann]

can u share/upload a sample qvw which demonstates the issue?

[Thiago_Justen_]

Did you try it  with double quotes? 

And what about this?

Max({$<[SalesQuantity]={"=Sum(SalesQuantity)>0"}>}TransDate)

[Sergey1]

Yes, with double quotes.

Max({$<[SalesQuantity]={"=Sum(SalesQuantity)>0"}>}TransDate) didn't work too

[Thiago_Justen_]

What about this?

FirstSortedValue(TransDate,-Aggr(Sum(SalesQuantity)>0,TransDate))

Or

Max( Aggr (If (Sum(SalesQuantity)>0,TransDate),TransDate ) )

[Sergey1]

I think I understand the reason
I have calc dimension
=aggr(if(sum([SalesQuantity])=0,[Product]),[Product])

The goal is to get only those products for which there was no sale for the selected period.
This is the reason why there is no sale date))
So I have to remove the period filters when I get the last dates.

[Thiago_Justen_]

It's an important thing to know...