Rolling 6 months data - variables not working in filter

Sakura — Wed, 19 Sep 2018 16:59:54 GMT

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)

sum({<YrMnth={">=$(vStart)<=$(vEnd)"}>}Actual)

None of them are working in Chart matrix.

Please help.

Re: Rolling 6 months data - variables not working in filter

vamsee — Wed, 19 Sep 2018 18:03:12 GMT

Try

Sum({<YrMnth={">=$(=vStart)<=$(=vEnd)"}>}Actual)

If it does not work check if Sum(Actual) populates the chart just to be sure.