topic Expression help in QlikView

Expression help

danielnevitt — Thu, 04 Feb 2016 16:18:03 GMT

Hi,

I am trying to create an expression which returns the bl_dt when I have a max modify_dt. Is that possible?

If so, any help would be much appreciated.

Regards,

Daniel

MK_QSL — Thu, 04 Feb 2016 16:18:34 GMT

Provide some more information..

swuehl — Thu, 04 Feb 2016 16:20:47 GMT

Should / could be possible. Maybe use FirstSortedValue():

=FirstSortedValue(DISTINCT bl_dt, -modify_dt)

modify_dt needs to have a numeric representation.

danielnevitt — Thu, 04 Feb 2016 16:22:23 GMT

Hi Manish,

Suppose I have the following data:

Modify_Dt Bl_Dt

01/02/2016 10/02/2016

02/02/2016 11/02/2016

03/02/2016 12/02/2016

04/02/2016 13/02/2016

I would like to create an expression that calculates the max Modify_Dt as 04/02/2016 and then returns 13/02/2016.

The next step is to take that result and show the differences between the date and today.

Hope that makes sense.

Regards,

Daniel