Identify last day of month with posted values

[#1]

Dear Qlk Users,

I have a very simple data model just constisting of e.g. 10 days of a month where only day 1 - 1 are filled with values. The remaining days are empty.

Which statement can I use to give me the result "5" being the last day filled with values?

I tried something like this ithout success:

[Day]={"<=$(=max({<[Value]>} [Day]))"}

And this is the data I am talking about:

Day	Value
1	100
2	150
3	30
4	20
5	80
6
7
8
9
10

[vishsaggi]

May be this I am not sure just try ?

= MinString({< Value = {''}   >} Day-1)

[vishsaggi]

Let us know if your requirement is something else. Check this attached app as well.

[Nicole-Smith · Accepted solution]

=max({<Value={'>0'}>}Day)

[sunny_talwar]

If Value is an expression such as Sum(Value), then may be this:

=Max({<Day = {"=Sum(Value) > 0"}>} Day)

[#6]

Try this Daniel

=if(aggr(sum(value)>0,Day),max(Day))

[#7]

Great,

all working solutions. I have tested all of them.

Finally I have chosen Nicoles approach which I find most easy to understand.

Thanks a lot!

Daniel