topic select the minimum date based on amount which is same in last few days. in QlikView

select the minimum date based on amount which is same in last few days.

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

Hi all,

I have a table like this.

Date Amount

01-Dec-16 10

02-Dec-16 15

03-Dec-16 10

04-Dec-16 20

05-Dec-16 20

06-Dec-16 20

07-Dec-16 15

08-Dec-16 15

09-Dec-16 15

10-Dec-16 15

11-Dec-16 15

Here, the last date(11-Dec-16 ) Amount is 15. so i need the last date amount(15) is not changed with continuously from which date.

here, my table 15 is not changed from 07-Dec-16. so this is the answer. but not 02-Dec-16, because the value 15 changed next day.

my answer is 07-Dec-16. how i get this is qlikview expression.

Anil_Babu_Samineni — Thu, 27 Oct 2016 01:57:04 GMT

Bit Confusing exactly what your Intend.

From This Table what was the Expected O/P

tresB — Thu, 27 Oct 2016 04:51:20 GMT

First you have to play a bit in creating a flag in the script and finally use that flag in set analysis expression in the UI.

Then use expression:

=Date(Max({<FinalFlag={1}>}Date))

jeevays7 — Fri, 28 Oct 2016 10:52:43 GMT

Hi tresesco,

Thank you for your reply. but i need only in front end. not in script.

can do this in only expression ??