topic Last date before a certain date in QlikView

Last date before a certain date

Tue, 24 Sep 2013 20:42:20 GMT

Hi everyone.

I'm trying to create a expression where I show the last date associated with a product before the date selected.

For example, I want to see the last date associated with a product before 2012-12-31.

If Product A has 2012-10-10,2012-01-01,2013-04-04 dates associated with it, then the last date before 2012-12-31 is 2012-10-10.

Can anybody help me?

Clever_Anjos — Tue, 24 Sep 2013 21:12:36 GMT

=max({1<[yourDate]={"<$(=max([yourDate]))"}>}[yourDate])

Wed, 25 Sep 2013 18:36:55 GMT

Thank you so much for your answer. This is almost what I need.

I need to select the last date prior a selected date. This selected date will be stored in a variable so my expression will be something like

=date(max({1<P_DATE={"<$(=V_DATE)"}>} P_DATE))

But I can't seem to make this expression work with a variable.

Clever_Anjos — Wed, 25 Sep 2013 18:38:39 GMT

What didn´t worked?

Wed, 25 Sep 2013 18:52:06 GMT

Never mind, I just managed to make it work. My variable V_DATE wasn't in the correct Date Format before but now it's fixed. Thank you for your help!