Use Date measure as a filter

[Qlik333]

Hello,

I created a calculated date measure using the following formula. How can I use the result of this measure as a dimension filter? Eventually I'll convert it to get the Year and Month string. 

=Date(RangeMin(Max([Date 1]),Max([Date 2])))

I am new to Qlik Sense, and I am a user not a developer.

Any help will be greatly appreciated.

[Qlik333]

Hello,

I created a calculated date measure using the following formula. How can I use the result of this measure as a dimension filter? Eventually I'll convert it to get the Year and Month string. 

=Date(RangeMin(Max([Date 1]),Max([Date 2])))

I am new to Qlik Sense, and I am a user not a developer.

Any help will be greatly appreciated.

[rwunderlich]

You can add this as a calculated Dimension by adding an Aggr() like this:

Aggr(Date(RangeMin(Max([Date 1]),Max([Date 2]))), somedim)

The Aggr must specify a field(s) "somedim" that you want to do this calculation over. This is also the field where selections will be made.  "somedim" would likely be a another dimension in your chart. 

You might also want to consider creating this new field in your script.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com