Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pnn44794
Partner - Specialist
Partner - Specialist

Rolling 13 Month View Not Working As Expected

Hello:

I had asked for assistance with this in an earlier thread and we thought we had it working, but it is not.  I have a stacked bar chart where I would like to have a 13 month rolling view of the data.  I'm using the following expression:

=Sum({<Date={">=$(=MonthStart(Today(),-12))<=$(=MonthEnd(Today()))"}>}CHARGE_AMOUNT)

When I first put this in place, it appeared to work as 201509 through 201609 was displayed.  However, I've now loaded 201610 data and instead of seeing just 201510 through 201610, I'm seeing 201509 through 201610.  I want 201509 to fall off.

Any ideas?  As usual, any and all help will be appreciated.  Thanks in advance.

22 Replies
eduardo_sommer
Partner - Specialist
Partner - Specialist

Yes, you need the as CHARGE_MONTH. The quotes are optional in this case.

Eduardo

pnn44794
Partner - Specialist
Partner - Specialist
Author

Eduardo:

 

Ok.

eduardo_sommer
Partner - Specialist
Partner - Specialist

Hi Perry

I suggest you to create some fields, derived from your date to use as dimensions in your charts. You can even use the original CHARGE_MONTH as a dimension. You use the date format in your set analysis and the string format. The numbers in your dimension are the numeric equivalent to the first day of each month. Qlikview stores the values in dual format. The string part uses the mask you provided and the numeric part is the number of days passe since 12/30/1899.

Here is a very good document on Qlikview dates:https://community.qlik.com/servlet/JiveServlet/downloadBody/3102-102-5-9741/DateFields-TechBrief-US_...

Eduardo