Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
=max({<Value={'>0'}>}Day)
May be this I am not sure just try ?
= MinString({< Value = {''} >} Day-1)
Let us know if your requirement is something else. Check this attached app as well.
=max({<Value={'>0'}>}Day)
If Value is an expression such as Sum(Value), then may be this:
=Max({<Day = {"=Sum(Value) > 0"}>} Day)
Try this Daniel
=if(aggr(sum(value)>0,Day),max(Day))
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