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

Hi,

I want to download private files related to an opportunity in Salesforce. I've tried tfileFetch but it doesn't work.
I've tried using APIs but I can't make the link between the opportunity and the file to be uploaded to Salesforce.
Have you ever had this problem? Do you know how to retrieve these files? 

Thanks