All, I've been searching for an answer to this but I'm having no luck. I want to show the sales over the last 12 months, so for Jan-19 I want it to show the sum sales from Feb-18 to Jan-19. This in ...
Hello, I'm trying to calculate rollingperiods using set analysis. I have seen several posts related to calculating rollingperiods, but most of them address issues using calendars, or the user is l...
Hi Experts, I have created a dashboard. My requirement is want to show Last 15 Days Sales. My expression is like this: Sum({<Year=, Quarter=, Month=,Week=, TransactionDate={'>=$(=Da...
I'm looking to create a bar chart of a count over the last 7 days by day, so for today, sunday to saturday, tomorrow will show Monday to Sunday. I'm sure this is easy but I can't get to grips w...
Hi All, I'm trying to do a pretty straight forward rollingperiod calculation in Qlikview - at least it's pretty easy to do in Excel I'm calculating a rolling 4 week period - as per the below -&n...
Hi, I require help with rolling data. Table 1 is the raw data. I created table 2 to show the rolling amounts with the help of information on the forum. This table is working. Any ideas on h...
I need to create the figures in the bottom table as KPIs - just struggling with the expression for the 3 batch average - it works in my main table but I can't get it to work alone Can anybody help w...
Hi Community, I have show rollingperiod for 3 months(which I knew) but at the same time we should show average for the 3 months like below in Pivot table/ if possible in straight table. &n...
...nalysis with 2 AsOfMonth.Type: RQ (Rolling Quarter) and PRQ (Previuos Rolling Quarter) With no selections this expression returns no results or always 0: Sum({$< Account.ID = p...
Hi all, I was hoping someome can help me with an issue I have. I want to get the sum of sales in a pivot table for a period based on the selection made in the field MonthYear and I want to g...
