Date

07mishin — Tue, 22 Feb 2022 15:26:13 GMT

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.

Re: Date

hic — Tue, 22 Feb 2022 15:29:23 GMT

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

Re: Date

07mishin — Wed, 23 Feb 2022 10:28:15 GMT

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

topic Re: Date in App Development

Date

Re: Date

Re: Date