using date range in a calculated dimension

[gerrycastellino]

How do I get my date  to read from 2 variables in the dimension.

I know I could use aggr , having difficulty constructing the syntax.

=aggr(only({<xDate='>=' &vMinDate & '<=' &vMaxDate >} xDate), xDate)

see attached.

Gerry.

[Vegar]

Your only set modifier looks a bit off.
Try something like this.

aggr(only({<xDate='{">=$(=$(vMinDate)) <= $(=$(vMaxDate))}" >} xDate), xDate)

[gerrycastellino]

 Did not work.... 😞

[PrashantSangle]

can you explain little bit more about your requirement.
What is dimension? what is measure? and what is chart type??
Instead of using date range in calculated dimension, use it in measure.

[Vegar]

First make sure that your Only() expression works. Create a straight table with xDate as dimension and your Only expression without the aggr() as a measure.

[gerrycastellino]

Prashant:

Just trying to drive my date dimension from 2 input date variables vMinDate, vMaxDate.

some of the trigger functionality in QV is a bit erratic,  trying to work around that.

Gerry.