topic Re: Problem with circular reference in QlikView

Problem with circular reference

alnocetti — Tue, 15 Aug 2017 20:06:23 GMT

Hello good afternoon.

I'm having a problem with a circular reference, I leave attached the catch.

Basically it is an application that analyzes sales, it has customers, items, sales, and a calendar.

The problem is that I was asked for a tab that shows, among other things, the number of active customers (per month-year), for each seller (as you will see, the relationship is one-to-one between seller and customer).

I already have a table (CustomersPerSeller -> (ClientesPorVendedor)), where the fields are: seller, month-year, otal (number of active customers).

Any way to fix it?

Is the correct way a linked table?, should i re-estructure all the data?

Thanks in advance.

Re: Problem with circular reference

vishsaggi — Tue, 15 Aug 2017 20:54:14 GMT

I believe your calendrio table should have all the calendar fields. Remove %emp_fecha from your Calendrio script and re run.

Re: Problem with circular reference

alnocetti — Thu, 17 Aug 2017 12:53:06 GMT

But i need this table(Calendario) linked to "Ventas" -> (Sales), because every tab in the app, have a date filter, if i remove this field (%emp_fecha), i'll lose those filters.

Re: Problem with circular reference

vishsaggi — Thu, 17 Aug 2017 15:31:15 GMT

What field is this %emp_fecha can you share this calendrio script you are using? I want to know from which table source you are getting this %emp_fecha?