Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a scenario where i have location monthname and the measure value. I need to develop the qlikview report in such a way that i should get the measure value for each location for each month.
If there is no value associated for a month for a location i should pickup the latest measure value for the latest month prior to missing month. It need not be the previous month.
Below is the example of the scenario. Can any one suggest me
Actual Value | Expected Value | ||||||
Location | Month | Value | Location | Month | Value | ||
A | Jan-15 | 100 | A | Jan-15 | 100 | ||
A | Feb-15 | 200 | A | Feb-15 | 200 | ||
A | May-15 | 400 | A | Mar-15 | 200 | ||
A | Aug-15 | 100 | A | Apr-15 | 200 | ||
A | Jan-16 | 300 | A | May-15 | 400 | ||
A | Apr-16 | 200 | A | Jun-15 | 400 | ||
A | Jun-16 | 400 | A | Jul-15 | 400 | ||
A | Aug-15 | 100 | |||||
A | Sep-15 | 100 | |||||
A | Oct-15 | 100 | |||||
A | Nov-15 | 100 | |||||
A | Dec-15 | 100 | |||||
A | Jan-16 | 300 | |||||
A | Feb-16 | 300 | |||||
A | Mar-16 | 300 | |||||
A | Apr-16 | 200 | |||||
A | May-16 | 200 | |||||
A | Jun-16 | 400 | |||||