topic Re: Join Table is causing loop in QlikView

Join Table is causing loop

RighettiAndrea — Wed, 01 Mar 2023 09:45:32 GMT

Hi everyone,
I'm adding a new table (Production) to a report and it has to be linked to other two tables as shown below (red arrows).
The DateLink table was created in order to reach the two data fields in the table Controls with only one date field (in the Calendar table).

This is obiuvsly causing me a looping error. How can I avoid it?

Thanks!

Re: Join Table is causing loop

Cascader — Wed, 01 Mar 2023 12:17:54 GMT

change Date column in DateLink or Production to other name.

Load

Date as DateProduction,

City,

Product

resident x;

Re: Join Table is causing loop

RighettiAndrea — Wed, 01 Mar 2023 12:34:30 GMT

My issue is not the name of the fields, is what I want to achieve...

I need the Produtcion table connected to the Calendar table and also to the Products table...