Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to QV and this is what I need to be able to do.
The user wants to be able to filter based on the following criteria:
Measure is currently due (today and 24 months prior to today)
Measure is due in 1 - 3 months from today
Measure is due in 4 - 6 months from today
Measure is due in 7 or more months from today
This would be based on the difference between the reporting period (MMYYYY) and the due date(MM/DD/YYYY).
Right now I have the due date calculated as a dimension based on some complex logic.
Any guidance would be greatly appreciated.
