Hello, this tutorial is really helpfull! I just have a question about the running average. I would like to use it for calculate the 12 months rolling, both in a line chart, bar chart but especially in a table! In the example you show only one dimension (the year-month). 1) What about if I want to add more dimensions, for example a product ? The "above" function how understand that it still hast to jump from a period (year-month) to the above one, and not from a product to the above one? 2) Is it possible to show, in a table, only few information (let me say only 3 periods like 2022-Jan , 2022-Feb , 2022-Mar and the few products) but having the 12 months rolling still working ? So, meaning that on 2022-Mar I should be able to see the -11 months avg sales even thought in the table I do not show the 2021-Dec,2021-Nov, etc etc... It would be amazing if it is possible. Thank you I am going to subscribe , really useful tutorial and so well explained!
Hi , I would have a question! Hope you can help: ( Kindly bear with me , if it's too descriptive ) I want to replicate this running total in the data load editor on a field VALUE by Period The case is I have multiple dimensions about 8 -10 , so at a time if I select any period it should give me cumulative values till that period. Is that possible?
Let me know if the data set is legible, I finally got to add it in the 3rd try as it was getting disappeared after hitting send! (may be character limit issue , so I have split into two posts, Hope that's okay)
Fiscal Year Period Country Region Plant code Factory Business Unit KPI Type VALUE VALUE ( Local ) 2021 2 BR AM 451 ABC Sweets Payables YTD 200 80 2021 2 DE EMEA 563 CDE Chocolates Payables YTD 300 120 2021 2 USA AM 321 ABD Juices Payables YTD 400 160 2021 3 BR AM 451 ABC Sweets Payables YTD 150 60 2021 3 DE EMEA 563 CDE Chocolates Payables YTD 250 100 2021 3 USA AM 321 ABD Juices Payables YTD 320 128 2021 4 BR AM 451 ABC Sweets Payables YTD 50 20 2021 4 DE EMEA 563 CDE Chocolates Payables YTD 70 28 2021 4 USA AM 321 ABD Juices Payables YTD 100 40
I would like to accumulate the figures in the backend , so that when I select Period 4 , it shows me in front end Sum(VALUE) = 1840 & Sum(VALUE (Local)) = 736 Additionally there would one or two more dimensions , but for our purpose the above data should work Thanks very much in advance 😊
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass
📕 Get the Formula CheatSheet: www.thinkmetrics.se/cheatsheet
00:04:22 you could also switch the "Total function" from Auto to Sum and compare the SalesColumn with the Running Sales 😀
Nice 😊
Hi Thanks, Can you please use Zoom while writing expression, i cannot see it clear in my laptop screen is small.
Could you please make tutorial on Time Intelligence function on Qlik sense ?
How to fix order by if we have to use multiple dimension in the table
can we do same in line chart without table ? how above function works in that case?
Hi,
Yes, it works but i would use an AGGR() function along with it
Thanks again for posting awesome content 👏
Thanks for the support 👍🏻
do you also offer masterclass in powerbi?????
NO
Hello, this tutorial is really helpfull! I just have a question about the running average. I would like to use it for calculate the 12 months rolling, both in a line chart, bar chart but especially in a table! In the example you show only one dimension (the year-month).
1) What about if I want to add more dimensions, for example a product ? The "above" function how understand that it still hast to jump from a period (year-month) to the above one, and not from a product to the above one?
2) Is it possible to show, in a table, only few information (let me say only 3 periods like 2022-Jan , 2022-Feb , 2022-Mar and the few products) but having the 12 months rolling still working ? So, meaning that on 2022-Mar I should be able to see the -11 months avg sales even thought in the table I do not show the 2021-Dec,2021-Nov, etc etc... It would be amazing if it is possible.
Thank you I am going to subscribe , really useful tutorial and so well explained!
Great question. I'll look into it and get back to you with a tutorial.
Hi , I would have a question! Hope you can help: ( Kindly bear with me , if it's too descriptive )
I want to replicate this running total in the data load editor on a field VALUE by Period
The case is I have multiple dimensions about 8 -10 , so at a time if I select any period it should give me cumulative values till that period. Is that possible?
Hi, will look into it. Share the data sample if you can.
Let me know if the data set is legible, I finally got to add it in the 3rd try as it was getting disappeared after hitting send! (may be character limit issue , so I have split into two posts, Hope that's okay)
Fiscal Year Period Country Region Plant code Factory Business Unit KPI Type VALUE VALUE ( Local ) 2021 2 BR AM 451 ABC Sweets Payables YTD 200 80 2021 2 DE EMEA 563 CDE Chocolates Payables YTD 300 120 2021 2 USA AM 321 ABD Juices Payables YTD 400 160 2021 3 BR AM 451 ABC Sweets Payables YTD 150 60 2021 3 DE EMEA 563 CDE Chocolates Payables YTD 250 100 2021 3 USA AM 321 ABD Juices Payables YTD 320 128 2021 4 BR AM 451 ABC Sweets Payables YTD 50 20 2021 4 DE EMEA 563 CDE Chocolates Payables YTD 70 28 2021 4 USA AM 321 ABD Juices Payables YTD 100 40
I would like to accumulate the figures in the backend , so that when I select Period 4 , it shows me in front end Sum(VALUE) = 1840 & Sum(VALUE (Local)) = 736 Additionally there would one or two more dimensions , but for our purpose the above data should work
Thanks very much in advance 😊
Font size it too big make it still smaller we got magnifying glass
👍🏻😂😂😂
Good
👍🏻