Restrict Dimension based on Date

[evansabres]

I have a straight table in which I want to only show the next ten events based on date. Is this possible within the structure of a straight table and if so, what is the expression? Dimension is EVENTDTE

[sunny_talwar]

You can either use calculated dimension to do this or use set analysis... both should be able to handle it... but I would try to do this via set analysis just because it tends to give better performance

[evansabres]

Thank you, how would the expression be structured?

[sunny_talwar]

What is your current expression?

[evansabres]

=SOLDQTY

[sunny_talwar · Accepted solution]

May be this

Only({<EVENTDTE = {"$(='>=' & Date(Today()) & '<=' & Date(Min({<EVENTDTE = {'>=$(=Date(Today()))'}>}EVENTDTE)))"}>} SOLDQTY)

[evansabres]

This makes the sold quantities appear as a null value. The aim is to have only the first ten event dates show, relative to today.

[sunny_talwar]

My bad, try this

Only({<EVENTDTE = {"$(='>=' & Date(Today()) & '<=' & Date(Min({<EVENTDTE = {'>=$(=Date(Today()))'}>}EVENTDTE, 10)))"}>} SOLDQTY)

There might be some syntax issue, but the idea to look for EVENTDUE which are greater than today and less than the next 10 EVENTDUE  days from today

[evansabres]

Thank you