Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.