loop while charging script

Wed, 28 Jun 2017 13:25:28 GMT

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

Re: loop while charging script

m_woolf — Wed, 28 Jun 2017 15:19:18 GMT

Recipes | Qlikview Cookbook

Re: loop while charging script

Thu, 29 Jun 2017 07:32:17 GMT

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

topic Re: loop while charging script in QlikView

loop while charging script

Re: loop while charging script

Re: loop while charging script