Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Identify last day of month with posted values

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:

DayValue

1

100
2150
330
420
580
6
7
8
9
10

1 Solution

Accepted Solutions
Nicole-Smith

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

View solution in original post

6 Replies
vishsaggi
Champion III
Champion III

May be this I am not sure just try ?

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

vishsaggi
Champion III
Champion III

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

Nicole-Smith

=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)

Not applicable
Author

Try this Daniel

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

Not applicable
Author

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