...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...
Hello everyone, Im creating a chart which displays the amount of new debtors per month. However, I want to only show the last12months in my chart and can't seem to fix it with a dimension limit....
...olling 12months only to the last12months. This resulted in limiting my result to only the lastmonth. So I tried a few ways to capture the date range: aggr(RangeSum(Above(Sum({$<Year>} {<D...
Hi All, I want to display on last12months in the month-year ribbon. In this example Jan-2017 should not be in the list. Could you please help me with the expression to write in the l...
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...
Hi,
I have two columns in my source file and they are in different format. The source file contains more than 12months of data and I need to filter out these not within last12months of the c...
...ales (Want to display all the record from current date till last12month) Could you please advise me how to show all the records by range dimension. the below condition I put on calculated d...
Hello All, I want show the data for last12months for each month. For example I have a columns like "Month-Year" and "Value" like below table, and for Jan-2018 it needs to show the sum of last...
...istinct count of target clients (target clients = clients active over the last12months, and that have the target value as OUI. Count ( {<TYPE_CALENDRIER={'N'},ORIGIN={'FACTURES'},[REG C...
...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...
