Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Yes, you need the as CHARGE_MONTH. The quotes are optional in this case.
Eduardo
Eduardo:
Ok.
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