Set analysis on possible values

[qw_jakub]

Hello,

I need two calendars to be alway set on the same days. I can not use just one, because it creates a loop.

The user should filter in Calendar_1 and Calendar_2 should be automitaclly filtered in the same way

I have tried a set expression like this:

= count({$<[Date_Calendar_2] = [Date_Calendar_1]>} distinct item_id) ,

but this works only if the user selects a date in Calendar_1 not if he selects a Month, or a Year.

Is there a way to make a set of dates in Calendar_2 of all possible dates values in Calendar_1?

Thanks for any tips!

J.

[swuehl · Accepted solution]

have you tried this?

= count({$<[Date_Calendar_2] = p( [Date_Calendar_1] ) >} distinct item_id)

[qw_jakub]

Thanks, this was it. I just recalled the p idenitfier myself.

This works.