topic Get the last event in QlikView

Get the last event

Thu, 18 Sep 2014 14:55:00 GMT

Hi,

You will find enclosed a rental car project example (it's filled with excel files)

My goal is to create a graphic table filtered with only "fin location" event (done) and in wich one the column GestionnaireDossier is filled with the name present in GestionnaireDossier for the event "debut location" for the same car

Actual :

What I try to do :

I tryed with firstsortedvalue and rank parameter but i can't figure out how it works ...

Any help will be great ...

Thanks in advance

Re: Get the last event

rubenmarin — Thu, 18 Sep 2014 15:14:08 GMT

Hi Christophe, check attachment to see if that's what you want.

Re: Get the last event

jagan — Thu, 18 Sep 2014 15:27:56 GMT

Hi,

Try like this

Dimension: Marque, Modele, DateEvenement

Expression:

NomEvenement = FirstSortedValue({<NomEvenement={'Fin Location'}>}NomEvenement, -DateEvenement)

GestionnaireDossier =If(IsNull([NomEvenement]), Null(), MaxString(TOTAL <Marque>GestionnaireDossier))

Hops this helps you.

Regards,

Jagan.

Re: Get the last event

Fri, 19 Sep 2014 06:45:16 GMT

Works fine ! Thank you !