...e Jan, Feb, Mar data while it has to showlast12Months of data based on selection and given below expression in Qlik Sense: Sum({$<type= {'A'}, date = {">=$(=Addmonths(Monthstart(Max(d...
Hi, I have spent ages looking at this and cant find a way to make it work. I have a number of graphs/tables i only want to show a set amount of months for (normally last12) Currently i am using t...
...selected 2017/07/31 from As of Date selector then the last12months should show from that date and those 2 measures should also calculate on the basis of that. So, I have created a Last12Month M...
...:mm:ss TT', e.g. 1/1/2018 11:04:35 AM) in the data model.
Ideally, the chart will default to the last12months relative to the present day's date (e.g., if today is 12 October 2022, it will show...
Hi all, I've been struggling with this for some time now. I want to make date 'format' in my load editor that show the last12months to date. I've found several examples in the community o...
...ategory A, I would like to show the average score for last12month of 202201-202212 and Category 1. (in this case is 11)
I user this to get 202212 and category A but cannot modify it to get last12months....
Hi there, I am working on a bar chart that counts a number of issues raised and shows it for the last12months (starting from the previous month). So for example, this month is May 2017; this m...
Hi! I'm trying to show a rolling 12month sum for the latest 12months, but the calculations are affected by the filtering of my Dimension axis to only display the last12months. I want the v...
...oday(), -1)),'MMM-YYYY'))"}>}Measurefield)
)
i want to show the default 12months rolling in my chart and i don't want to disable the data enabling -> include zero values, because i...
...n the vertical axis. The objective is to have the chart always show the per category sale amount for the last12months from the current month. I assume the measure value has to be calculated u...
