Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Sakura
Creator
Creator

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
Specialist
Specialist

Try

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


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