Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Sakura
Contributor

Rolling 6 months data - variables not working in filter

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.

1 Reply
vamsee
Valued Contributor

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

Try

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


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