topic Re: Group by max date in straight table in QlikView

Group by max date in straight table

Wed, 27 Jul 2016 00:06:43 GMT

Hi Guys

I have below table and I only want to get one row per document Id with the last download date and downloaded by.

Sample QVW attached.

Wed, 27 Jul 2016 00:41:56 GMT

How about this?

Digvijay_Singh — Wed, 27 Jul 2016 00:56:08 GMT

Use Firstsortedvalue smthg like -

Dimension - DocumentId

Exp1 - firstsortedvalue(DownloadedBy,-Download Date])

Exp2 - firstsortedvalue(UploadDate,-Download Date])

Exp3- firstsortedvalue([Download Date],-Download Date])

Wed, 27 Jul 2016 01:00:55 GMT

Try this.

sunny_talwar — Wed, 27 Jul 2016 01:54:30 GMT

Are you looking to get this done in the script or front end?

Wed, 27 Jul 2016 03:43:43 GMT

front end

Wed, 27 Jul 2016 03:47:02 GMT

Just one more question related to this example...

How to get all the document Ids (even if there is no download date for that document?)

if the document has download date then it should show last download date.. else null