Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
agigliotti
Partner
Partner

Set analysis with Max function

Hello,

I'm stuck with the below expression:

Sum( {< Field1={"SALES"}, Field2={"EEEE"} >} if( DeliveryDate = Max(DeliveryDate), Quantity, 0 ) )

using the following dimensions: customer, delivery number, delivery date

I need to SUM only the items sold in the last delivery for each customer.

How can I achieve it ?

Please help me.

Best Regards

Andrea

21 Replies
elyM
Partner
Partner

Hi Andrea,

I have tested this expression on your qvw

RangeSum(If([%Data] = Max({$< %TipoVenditaLink={"VENDITA"}, DirettoGrossista={"Diretto"}, CategoriaArticoloID={"122"}, Vendite.Tipo.Documento -= {"RESI"} >} TOTAL<Cliente> %Data),sum(Qta),0))



Regards,

Ely

agigliotti
Partner
Partner

Hi Ely,

I'll let you know asap if your suggested expression give me the right result.

Many thanks for your collaboration.

Best Regards

Andrea