...he last 12monthsrolling whilst comparing this years data with last years. Does that make sense?
So a monthly bar chart showing each months variance to the year before, across a rolling12months.&n...
...otal of the count of issues for April, March, February, January, December, November. and then the same pattern for the other 11 months. So far my set analysis is as follows to achieve the 12monthrolling...
...ata and so on so forth.
I have managed to get the rolling period working for the most recent 12 period. However, I cant get rid of the rest of the axis, and also I would prefer to show i...
...asically it takes 12month Net sales / 3 month average inventory value. Now to my problem: The first 12month will always show incorrect values because of my rangesum formula. If I were to selct 2...
Hello Experts!!, I need to show the value of a month, and the value of the rolling12 of this month in Qlik Sense. Sample data:
Data:
LOAD
Date(D) as D
,DateNum
,Value
;
L...
...owever it shows same Top 10 Debtors as ranked for last month for the rolling period of 12months. I would like to show Top 10 Debtors to be calculated for each months of rolling12months. Measure is d...
Hi everyone, I want to have rolling12months on Sum and Count measure. I have seen many post related to this, but nothing worked well with my scenario- here is my scenario - I have field as = T...
Hello. I have data similar to the below. In my load script, I want to have a three monthrolling cumulative by Customer and Dept (or six month or 12month or etc). So for month end 2/29 f...
Hi Everyone, I need to create a flag in the Data modal for Rolling12months with respect to Current Quarter start. So to test the expression i have wrote it in a list box and the logic feels c...
...023, 1
A, 16/06/2023, 1
B, 16/04/2023, 1
B, 18/04/2023, 1
How to do a rolling12month, counting products in the last 12month that have sold more than 2 times.
I want to build a bar c...