Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

alnocetti
New Contributor

Problem with circular reference

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.

3 Replies
vishsaggi
Esteemed Contributor III

Re: Problem with circular reference

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

alnocetti
New Contributor

Re: Problem with circular reference

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.

vishsaggi
Esteemed Contributor III

Re: Problem with circular reference

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?