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)
For example:
| Item |
BeginGuarantee |
EndGuarantee |
| 1 |
01/Jan/2014 |
01/Jan/2016 |
| 2 |
01/April/2014 |
01/April/2016 |
| 3 |
01/July/2014 |
01/July/2016 |
desired Result:
| Month - Year |
Items_in_Guarantee |
| Jan 2014 |
0 |
| Feb 2014 |
1 |
| March 2014 |
1 |
| April 2014 |
1 |
| May 2014 |
2 |
| June 2014 |
2 |
| July 2014 |
2 |
| August 2014 |
3 |
| September 2014 |
3 |
| Oktober 2014 |
3 |
%20(1).JPG){kind=link}