topic Re: the last date in QlikView

the last date

sebastianolivar — Tue, 20 Nov 2018 21:30:40 GMT

Hello Comunity,

I am Sebastián. I have a little problem whit a expresion.

for example:

I have the sales of each stores with yours date of sales.

I need a expression to get the last sale (according the date) to each Store.

I tried with sum( {< Date sale= {"$(=date(max(Date sale)))"} >} Sales , but its not working.

Vegar — Tue, 20 Nov 2018 21:36:37 GMT

Try
Sum(
If( [Date sale]= max([Date sale]),Sales,0)
)

Anonymous — Wed, 21 Nov 2018 00:26:05 GMT

sum(if([Date Sale] = aggr(Max([Date Sale]),Customer,Store),Sales))