Date

[07mishin]

Good day.
I have a table.

#procedure	#contract	Date_contract	Date_procedure
111	111111	01.02	01.03
222	222222	01.03	01.02
333	333333	01.02	01.03

I need to make a filter that will select one time period for two entities.
For example, if you select 01.02 to select procedures: 111, 333 and contracts: 222.
I tried to make an additional calendar:

sPeriodStart = Floor((MakeDate(2021, 1, 1)));
sPeriodEnd = Floor(Today());
let v_MaxData = '$(sPeriodEnd)';
let v_MinData = '$(sPeriodStart)';
let v_h_max_data = num(v_MaxData);
let v_h_min_data = num(v_MinData);

[Calendar]:
LOAD
    Date(num($(v_h_min_data)) + IterNo() - 1) as "Date_contract",
    Date(num($(v_h_min_data)) + IterNo() - 1) as "Date_procedure",
    Date(num($(v_h_min_data)) + IterNo() - 1) as "Date for filter"
AutoGenerate 1
While num($(v_h_min_data)) + IterNo() -1 <= num($(v_h_max_data));

, but there was a synthetic link.

[hic]

You probably need two different calendars for the two dates. See more on 

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578 

[07mishin]

Thanks, but I have 2 different entities, and I can't select 1 minimum object. For me they are both important.