4 Replies Latest reply: Aug 23, 2015 11:41 PM by arjun rao RSS

    Circular references

    Laura Sak.

      Hello, qlik community!

      Help my to solve my problem with the keys.

       

      I've got a model (just a sample)

       

      [Item.ledger]: loc.key, sales, costs, cal.key, ....

      [location]: loc.key, loc.city, loc.name, ...

      [Calendar]: cal.key, date, year, month, year&month...

      [Budget]: budget_amount, loc.city, year&month.

       

      I need a bar chart with the dimension of months and measures costs, sales, budget amount. And the 2nd chart with the dimension city and the same measures. I have got a circular refences with location city and year&month.

       

      If I try to concatenate function (concatenate (item.ledger) load * from budget, I have 4 syntetics keys and it no working nothing. My sales, costs and budget amount are zero. If I connect budget to the city, diagram with the dimension of month is not working.

       

      How to solve my problem? Any idieas?