This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
What is expression for Rolling Month of past 12 month & 6 month anyone can write the code here?
If you're looking for an average over the last 12 months you can do like below:
So this sums the "Field" where the "Date" is greater than the start of the month from today's date, 12 months ago, and the "Date" is less than the beginning of the current month.
You may not need this depending on your requirement.
I have used monthstart() function but if you need the exact date, 12 months ago you can replace it with addmonths(today(),-12)
I hope this helps.