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

[Marco_Antony]

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

[Alexis_Touet]

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.

[Joseph_Musekura · Accepted solution]

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]

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]

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 · Accepted solution]

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