Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I would like to calculate rolling sum like in the table below. Data should be grouped by column "Family". For each quarter I want to take a look at current quarter and 2 quarters backwards. Any idea how to achieve this in script editor? I am not interested in set analysis using rangesum - above combination. Column "Quarter" comes from fiscal master calendar.
Thank you.
Family | Quarter | Qty | RollingSum3 | Family,Quarter,Qty |
A | FY2023Q2 | 10 | 10 | A,FY2023Q2,10 |
A | FY2023Q3 | 20 | 30 | A,FY2023Q3,20 |
A | FY2023Q4 | 30 | 60 | A,FY2023Q4,30 |
A | FY2024Q1 | 40 | 90 | A,FY2024Q1,40 |
A | FY2024Q2 | 50 | 120 | A,FY2024Q2,50 |
A | FY2024Q3 | 60 | 150 | A,FY2024Q3,60 |
A | FY2024Q4 | 70 | 180 | A,FY2024Q4,70 |
B | FY2023Q2 | 5 | 5 | B,FY2023Q2,5 |
B | FY2023Q3 | 10 | 15 | B,FY2023Q3,10 |
B | FY2023Q4 | 15 | 30 | B,FY2023Q4,15 |
B | FY2024Q1 | 20 | 45 | B,FY2024Q1,20 |
B | FY2024Q2 | 25 | 60 | B,FY2024Q2,25 |
B | FY2024Q3 | 30 | 75 | B,FY2024Q3,30 |
B | FY2024Q4 | 35 | 90 | B,FY2024Q4,35 |
I have a bit of a difficult situation at hand. I have SFCs which are worked in specific work centers, for each work center an employee is assigned.
Then, each work center has different modules, maybe 2, 3 or 4 that could be completed each in their own sepcific time. The time is assigned as the difference between:
Max({<ACTION_CODE={'LABOR_OFF'}>}DateTime) - Min({<ACTION_CODE={'LABOR_ON'}>}DateTime)
And until here, everything is fine. Because until now it's only one product taken into account. But, for each SFC, there are AT LEAST one item between "PrimoRiduttore", "SecondoRiduttore" and "Motore".
So, an SFC can be composed by minimum of 1 and maximum of 3 different items. But these items are all worked in separate work centers and by different users (usually). Right now, I am taking into consideration only the time for the work center, so whichever item was made I wouldn't really care, because the duration would still be correct. But when I visualize this, I have no idea how to refer the user to the specific item they made
AKA I don't know how to make it so that, in the table, I could only see who worked on which item.
I am going to show you the data model as well, so it could be better understood.
So, to be able to associate a worker only to the specific item they worked on, I would like to have some help if possible. If need more information, please let me know.
Thank you
Hi Team
I'd like to know the requirements of network direction (e.g. from the source to Qlik, or bidirectional flow) between the source and Qlik Replicate and also the target and Qlik Replicate to configure the firewall rule between them, but I couldn't find any information about it. Could anyone let me know what kind of traffic flow should be necessary for the source and the target?
Thank you
I want that a unique value of date is selected and set the max date as default when the app is opened. But the interaction between this two issues does not seem to work well. Anyone knows how could I do it?
Bonjour
J'aimerais pouvoir ajouter un bouton dans mon board qui provoque l'action "Sélectionner des valeurs correspondant aux critères de recherche" avec plusieurs critères de recherche.
Par exemple, si je clique sur mon bouton, cela sélectionne les deux valeurs '- Aucun' et 'Absences et formations' pour le champ "Sujet imputation"
Merci d'avance !
Hello Everyone, I have a question for Qlik sense. I have a table that has a Date column and a quantity column. I need to create a master Item that calculates the month to date quantity.
I am attaching an Excel file that has those 2 columns and also the column of the MTD that I need to calculate as a master item
Can you please Help ?. Thanks
Bonjour,
Où trouve-ton la tâche planifiée de chargement de données de qlikview (version 12) ainsi que les informations associée horaire, fréquence déclenchement ... comme on le voit sur QMC de Qliksense ?
En vérifiant l'ensemble des tâches planifiées sous Windows, nous ne voyons pas de tâche planifiée portant de nom significative qui pourrait être associée à l'application qlikview.
On ne trouve pas assez de détail dans la documentation Qlikview.
Merci par avance.
Hi team,
using QEM's Python API is it possible to create new task using a previous task's export file. I want to create 10 tasks using a previous task's export file. I want to know if there is any function called create_task() or someway using which I can create task using python.
Dear all,
after several attempts, i need your help.
I have 2 tables composed as follows:
HIRE which contains the following fields:
HIRE_CODE HIRE_DATE (date field)
END_DATE_F (date field)
BRIDGE which contains the following fields: HIRE_CODE PREV_CODE START_DATE (date field) END_DATE (date field)
In the BRIDGE table, the period for which the PREV_CODE is valid for that hire (HIRE_CODE) is indicated.
I would like to create a new table where for each hire (PREV_CODE), the valid PREV_CODE is indicated for each month within the period indicated from HIRE_DATE to END_DATE_F.
The table I expect might be:
HIRE_CODE
PREV_CODE
YEAR
MONTH
Thanks for your support
Mauro
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!