topic Re: Selecting Max date and Max value to display Dimension in QlikView

Selecting Max date and Max value to display Dimension

adley51788 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am trying to display a dimension based on the max of two values. For example:

Engagement :: Date :: Level

A ,10/1/2015,3

A ,10/1/2015,2

A, 09/29/2015,3

B,10/2/2015,3

B ,10/2/2015,2

B, 09/29/2015,3

C ,10/2/2015,3

C ,10/2/2015,2

C, 09/29/2015,3

I would expect to see --

A,10/1/2015,3

B,10/2/2015,3

C,10/2/2015,3

Thank you!

sunny_talwar — Tue, 10 May 2016 16:39:23 GMT

Try this:

Dimension

Engagement

Expression

1) =Date(Max(Date))

2) =FirstSortedValue(Level, -(Date*10000 + Level))

adley51788 — Tue, 10 May 2016 22:53:28 GMT

Thank you for your response.

I am getting a null value for the level field in my data set. Would it be possible to display the max level even if the date is null?

Thanks!

sunny_talwar — Wed, 11 May 2016 13:51:54 GMT

Would you be able to share a sample for that scenario with the expected output?