topic Re: using date range in a calculated dimension in QlikView

using date range in a calculated dimension

gerrycastellino — Fri, 12 Apr 2019 05:24:21 GMT

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.

Re: using date range in a calculated dimension

Vegar — Fri, 12 Apr 2019 05:28:33 GMT

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

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

Re: using date range in a calculated dimension

gerrycastellino — Fri, 12 Apr 2019 05:38:48 GMT

Did not work.... 😞

Re: using date range in a calculated dimension

PrashantSangle — Fri, 12 Apr 2019 05:55:21 GMT

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.

Re: using date range in a calculated dimension

Vegar — Fri, 12 Apr 2019 06:04:40 GMT

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.

Re: using date range in a calculated dimension

gerrycastellino — Fri, 12 Apr 2019 14:12:35 GMT

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.