Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kavieweg
New Contributor II

Last record for latest timestamo

Hi togehter,

i would like to have the latest (eventtype and Kee) for the latest timestamp of the selected Customer

CustomerValDepotKeetimestampeventtype
A0406391441.522.783.109.000,006
A0406391431.522.782.099.000,005
A0406390841.522.763.602.000,004
A0406390601.522.754.579.000,003
A0406386631.522.199.638.000,0010
B0406385561.522.163.379.000,006
B0406385441.522.161.117.000,005
B0406384621.522.131.967.000,004
B0406384541.522.129.900.000,003
B0406382071.521.816.258.000,004
C0406381931.521.811.602.000,003
C0406381801.521.805.247.000,006
C0406381701.521.801.280.000,005
C0406375641.521.723.207.000,004
C0406375581.521.720.757.000,003

Thanks for help

Mathias

19 Replies

Re: Last record for latest timestamo

You need to do this in the script or front end?

kavieweg
New Contributor II

Re: Last record for latest timestamo

Hi Sunny,

in the first Version in the front end. But I am interested in both possible solutins.

Thank you in advance.

Mathias

Re: Last record for latest timestamo

May be try this

FirstSortedValue(Kee, -timestamp)

FirstSortedValue(eventtype, -timestamp)

kavieweg
New Contributor II

Re: Last record for latest timestamo

- this does not work. I Need the value e.g. eventtyp, for a selected customer.

So from a customer (here i have multiple entries for one Customer) the eventtyp of the latest record (timestamp)

Re: Last record for latest timestamo

I can show you what I mean by creating a sample, but I don't really understand your date field?... what kind of format is this?

1.522.783.109.000,00

kavieweg
New Contributor II

Re: Last record for latest timestamo

kavieweg
New Contributor II

Re: Last record for latest timestamo

milliseconds since 1970 :-)

kavieweg
New Contributor II

Re: Last record for latest timestamo

1522783109000

Re: Last record for latest timestamo

Is this what you wanted?

Capture.PNG

Community Browser