HOW TO CREATE Running TOTAL, Running Average, and Running Percentage in QLIK

[@thinkmetrics]

🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass 📕 Get the Formula CheatSheet: www.thinkmetrics.se/cheatsheet

[@saravana5720]

Hi Thanks, Can you please use Zoom while writing expression, i cannot see it clear in my laptop screen is small.

[@pascalhoffmann3725]

00:04:22 you could also switch the "Total function" from Auto to Sum and compare the SalesColumn with the Running Sales 😀

[@thinkmetrics]

Nice 😊

[@shashankhegde6844]

Thanks again for posting awesome content 👏

[@thinkmetrics]

Thanks for the support 👍🏻

[@pareshrahool3048]

Could you please make tutorial on Time Intelligence function on Qlik sense ?

[@ushakumari8474]

do you also offer masterclass in powerbi?????

[@thinkmetrics]

NO

[@babuv.k2541]

can we do same in line chart without table ? how above function works in that case?

[@thinkmetrics]

Hi, Yes, it works but i would use an AGGR() function along with it

[@samkaran6351]

How to fix order by if we have to use multiple dimension in the table

[@MattBellamy881]

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!

[@thinkmetrics]

Great question. I'll look into it and get back to you with a tutorial.

[@humtumhyderabadi108]

Good

[@thinkmetrics]

👍🏻

[@shashankhegde6844]

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?

[@thinkmetrics]

Hi, will look into it. Share the data sample if you can.

[@shashankhegde6844]

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)

[@shashankhegde6844]

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

[@shashankhegde6844]

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 😊

[@manjunathhn1]

Font size it too big make it still smaller we got magnifying glass

[@thinkmetrics]

👍🏻😂😂😂