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 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...
Hi, QlikView I have data set that shows sales number and date when they happen. I want to make a chart what shows sales numbers for last12 YearPeriod I will explain better. So today is 30.09...
Hi All, I have a user requirement. He wants to see 12months trends of particular KPI's in line graph. I have months from Jan to Dec as filter selections. His requirement is when November 2015 i...
Hi guys, I would like to show Sales as standard for the sum of the lastmonth until the last12months before that. i know have it on a yearly level: =Sum({<PeriodMath={'>=$(v...