Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Marco_Antony
Contributor II
Contributor II

Deux Table liées or Two Related Tables - Qlik Sense

DGE:
LOAD
"PHP SBM" as Etat,
F2 as Libellé,
F3 as "Libellé Second",
Num(F4, 0.0) as "Budget Annuel",
Num(F5, 0.0) as "Budget Mensuel",
Num(F7, 0.0) as "Réel 1",
Num("SERVICES CENTRAUX", 0.0) as "QP Budget 1",
FROM [lib://Rep_CDR22/Dir R22.xlsx]
(ooxml, embedded labels, table is DGE);


Rex:
LOAD
"PHP SBM" as Etat,
F2 as Libellé,
F3 as "Libellé Second",
Num(F4, 0.0) as "Budget Annuel",
Num(F5, 0.0) as "Budget Mensuel",
Num(F7, 0.0) as "Réel 1",
Num("SERVICES CENTRAUX", 0.0) as "QP Budget 1",
FROM [lib://Rep_CDR22/Dir R22.xlsx]
(ooxml, embedded labels, table is Rex);

 

 

j'aimerais pour faire des filtres sur chaque table sans changer le noms des champs.

Merci

 

Translated:

CEO:
LOAD
"PHP SBM" as State,
F2 as Label,
F3 as "Label Second",
Num(F4, 0.0) as "Annual Budget",
Num(F5, 0.0) as "Monthly Budget",
Num(F7, 0.0) as "Real 1",
Num("CENTRAL SERVICES", 0.0) as "QP Budget 1",
FROM [lib://Dir_CDR22/Dir R22.xlsx]
(ooxml, embedded labels, table is DGE);

Rex:
LOAD
"PHP SBM" as State,
F2 as Label,
F3 as "Label Second",
Num(F4, 0.0) as "Annual Budget",
Num(F5, 0.0) as "Monthly Budget",
Num(F7, 0.0) as "Real 1",
Num("CENTRAL SERVICES", 0.0) as "QP Budget 1",
FROM [lib://Dir_CDR22/Dir R22.xlsx]
(ooxml, embedded labels, table is Rex);


I would like to make filters on each table without changing the field names.

Thanks
Labels (2)
2 Solutions

Accepted Solutions
Joseph_Musekura
Support
Support

Bonjour @Marco_Antony ,

Comme Mr. Alexis l'a souligné, il est nécessaire de renommer les champs d'une de vos 2 tables car comme le nombre et les noms des champs de pces 2 tables sont exactement identiques, Il y aura concaténation et comme résultat une seule table sera chargée Concatenating tables 

Pour éviter une concaténation automatique, il faut renommer les champs d'une de vos 2 tables

 

Translated:

Hello @Marco_Antony,

As Mr. Alexis pointed out, it is necessary to rename the fields of one of your 2 tables because as the number and the names of the fields of the 2 tables are exactly identical, there will be concatenation and as a result a single table will be loaded Concatenating tables

To avoid an automatic concatenation, you must rename the fields of one of your 2 tables

 

View solution in original post

Joseph_Musekura
Support
Support

Hi @Marco_Antony

Vous pouvez renommer les champs d'une façon automatique en utilisant QUALIFY (https://help.qlik.com/fr-FR/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...) .

Il faudra cependant se rappeler d'utiliser UNQUALIFY (https://help.qlik.com/fr-FR/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...) pour garder les noms des champs utilisés dans l’association des données (tables).

/joseph

 

Translated:

You can rename fields automatically using QUALIFY (Qualify) .

However, remember to use UNQUALIFY (Unqualify) to keep the names of the fields used in the data association (tables).

/joseph

 

View solution in original post

5 Replies
Alexis_Touet
Former Employee
Former Employee

Bonjour @Marco_Antony 

Il sera nécessaire de renommer les champs pour qu´ils aient des noms différents.

 

Translated:

It will be necessary to rename the fields so that they have different names.
Please don't forget to mark a correct resolution or answer to your problem or question as correct, as it will help other members to find solutions more easily 😉
Joseph_Musekura
Support
Support

Bonjour @Marco_Antony ,

Comme Mr. Alexis l'a souligné, il est nécessaire de renommer les champs d'une de vos 2 tables car comme le nombre et les noms des champs de pces 2 tables sont exactement identiques, Il y aura concaténation et comme résultat une seule table sera chargée Concatenating tables 

Pour éviter une concaténation automatique, il faut renommer les champs d'une de vos 2 tables

 

Translated:

Hello @Marco_Antony,

As Mr. Alexis pointed out, it is necessary to rename the fields of one of your 2 tables because as the number and the names of the fields of the 2 tables are exactly identical, there will be concatenation and as a result a single table will be loaded Concatenating tables

To avoid an automatic concatenation, you must rename the fields of one of your 2 tables

 

Marco_Antony
Contributor II
Contributor II
Author

Bonjour, 

Je pense que s'il on avait 100 tables et 10.000 champs cela devrait un travail monstre.

Je pense encore que Qlik doit avoir une condition pour faire des filtres spécifiques.

Car renommer je l’ai fait mais je voulais une méthode plus automatique.

Marco_Antony
Contributor II
Contributor II
Author

Bonjour Zarra.

En effet ce sont les données d'une feuille de calcul Excel mais sur des onglets, dont je dois faire des analyses et graphes via Qlik Sense.

 

Car c’est le même fichier avec les mêmes champs mais les valeurs différentes

 

Mon problème est de pouvoir faire des filtres dans mes différentes tables sans devoir changer le nom des libellés.

 

Actuellement j’ai 03 trois tables, (DGE, Rex et Sec) et je dois faire des feuilles d’analyse pour ses trois tables.

 

Mais quand je veux ajouter les champs je suis bloqué car les champs ont le même nom mais les valeurs différentes.

 

Comment dire a Qlik de sélectionner juste les données de la table DGE et non celle Rex et Sec ?

 

DGE:

LOAD

    "PHP SBM" as Etat,

    F2 as Libellé,

    F3 as "Libellé Second",

    Round(F4) as "Budget Annuel",

    Round(F5) as "Budget Mensuel",

    Round(F7) as "Réel n",

    Round("SERVICES CENTRAUX") as "QP Budget",

    Round(F9) as "Ecart Valeur",

    Round(F10) as "Ecart %",

    F25 as Commentaire,

    Round(AA) as "Projection Calculée",

    Round(AB) as ESTIME,

    Round(AC) as RETENU,

    Round(AD) as "ECART BUDGET"

FROM [lib://Rep_CDR22/Dir R22.xlsx]

(ooxml, embedded labels, table is DGE);

 

 

Rex:

LOAD

"PHP SBM" as Etat,

    F2 as Libellé,

    F3 as "Libellé Second",

    Round(F4) as "Budget Annuel",

    Round(F5) as "Budget Mensuel",

    Round(F7) as "Réel n",

    Round("SERVICES CENTRAUX") as "QP Budget",

    Round(F9) as "Ecart Valeur",

    Round(F10) as "Ecart %",

    F25 as Commentaire,

    Round(AA) as "Projection Calculée",

    Round(AB) as ESTIME,

    Round(AC) as RETENU,

    Round(AD) as "ECART BUDGET"

FROM [lib://Rep_CDR22/Dir R22.xlsx]

(ooxml, embedded labels, table is Rex);

 

Sec:

LOAD

 "PHP SBM" as Etat,

    F2 as Libellé,

    F3 as "Libellé Second",

    Round(F4) as "Budget Annuel",

    Round(F5) as "Budget Mensuel",

    Round(F7) as "Réel n",

    Round("SERVICES CENTRAUX") as "QP Budget",

    Round(F9) as "Ecart Valeur",

    Round(F10) as "Ecart %",

    F25 as Commentaire,

    Round(AA) as "Projection Calculée",

    Round(AB) as ESTIME,

    Round(AC) as RETENU,

    Round(AD) as "ECART BUDGET"

FROM [lib://Rep_CDR22/Dir R22.xlsx]

(ooxml, embedded labels, table is Sec);

Joseph_Musekura
Support
Support

Hi @Marco_Antony

Vous pouvez renommer les champs d'une façon automatique en utilisant QUALIFY (https://help.qlik.com/fr-FR/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...) .

Il faudra cependant se rappeler d'utiliser UNQUALIFY (https://help.qlik.com/fr-FR/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...) pour garder les noms des champs utilisés dans l’association des données (tables).

/joseph

 

Translated:

You can rename fields automatically using QUALIFY (Qualify) .

However, remember to use UNQUALIFY (Unqualify) to keep the names of the fields used in the data association (tables).

/joseph