Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created one column YrMnth in qvw with Year&Month (e.g.201812) in the source query which is working fine.
Created 2 variables as vStart which is 6 months before (201806) and vEnd (201812)as will give month selected.
When I try:
sum({<YrMnth={">=$(vStart)"}>}Actual)
OR
sum({<YrMnth={">=$(vStart)<=$(vEnd)"}>}Actual)
None of them are working in Chart matrix.
Please help.
Try
Sum({<YrMnth={">=$(=vStart)<=$(=vEnd)"}>}Actual)
If it does not work check if Sum(Actual) populates the chart just to be sure.