Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |