Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have the simplified script version 1 below :
LOAD [Code Analyse],
Mois,
Année,
[Nbr analyses]
FROM abc
LOAD Machine,
Mois,
Année,
Cost,
FROM abc
LOAD Réactif,
[Cout réactif],
Mois,
Année
FROM abc
What I want is : for exemple, when I select "January" in Month, qlikview needs to find every "CodeAnalyse", "Machine" information and "Reactif" information that are on the same month January.
qlikview displays the message of "loop error" while charging the script, which is expected because the couple Month and Year is repeated in almost every table. But if I changed the name of Month and Year (script version 2), when I select for exemple January in MonthAnalyse, it can't get the information of Machine and Reactif of January.
Script v2 :
LOAD [Code Analyse],
MonthAnalyse,
YearAnalyse,
[Nbr analyses]
FROM abc
LOAD Machine,
MonthMachine,
YearMachine,
Cost,
FROM abc
LOAD Réactif,
[Cout réactif],
MonthReactif,
YearReactif
FROM abc
Can anyone help me to find how we can resolve the "loop problem" and still keep Month and Year as a common dimension for all tables?
Thank you very much for your help
Thank you.
I will try to do as the "recipe". I don't know if it will work in my project but I will mark your response correct.
If there is any problem, may I come back to you
Thanks again