5 Replies Latest reply: Aug 1, 2018 1:01 PM by pablo trevisan RSS

    How to solve circular reference?

    Le-Hao Nguyen

      Hi guys,

       

      im new to Qlik and i got a problem i can't solve.

      i got two fact tables  and one meta table

       

      A:

      UserIDDatePageCount
      320-07-2017155
      420-08-2016199
      320-07-2017311

       

      B:

      UserIdWorkDateWorkDuration
      320-07-201703:41:33
      420-08-201606:01:13
      320-07-201702:51:21

       

      C:

      UserIdName
      3David
      4Michael

       

       

      now i want to see how much pages a user do on a specific date. its no problem when i filter on both date and workdate but when i want to use only one date filter i always get circular references because userid's are also linked already.