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

[jeevays7]

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]

Bit Confusing exactly what your Intend.

From This Table what was the Expected O/P

[tresesco]

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]

Hi tresesco,

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

can do this in only expression ??