Logically I understand very well the needed task but problem with the qlik language.
I have to create a dashboard which shows a canonical calendar which show the total quantity of items, which have a begin and end of guarante date respectively, are outside of the selected date-year. ( I created alredy the master calendar and bridge)
Time Lapse is from 2012 - 2028 with a monthly step.
Basically Condition is the following:
Count ( If ( BeginGuarantee < StartMonthYear and EndGuarantee > EndMonthYear)
%20(1).JPG){kind=link}