topic Last sale date (set analyses) in QlikView

Last sale date (set analyses)

Sergey1 — Sat, 16 Nov 2024 05:10:39 GMT

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

Re: Last sale date (set analyses)

Thiago_Justen_ — Wed, 21 Nov 2018 12:18:34 GMT

Try this out:

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

Re: Last sale date (set analyses)

Sergey1 — Wed, 21 Nov 2018 12:22:27 GMT

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

But it doesn't work

Re: Last sale date (set analyses)

Frank_Hartmann — Wed, 21 Nov 2018 12:23:53 GMT

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

Re: Last sale date (set analyses)

Thiago_Justen_ — Wed, 21 Nov 2018 12:24:45 GMT

Did you try it with double quotes?

And what about this?

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

Re: Last sale date (set analyses)

Sergey1 — Wed, 21 Nov 2018 12:29:29 GMT

Yes, with double quotes.

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

Re: Last sale date (set analyses)

Thiago_Justen_ — Wed, 21 Nov 2018 12:34:04 GMT

What about this?

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

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

Re: Last sale date (set analyses)

Sergey1 — Wed, 21 Nov 2018 12:34:23 GMT

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.

Re: Last sale date (set analyses)

Thiago_Justen_ — Wed, 21 Nov 2018 12:35:30 GMT

It's an important thing to know...