7 Replies Latest reply: Apr 22, 2015 10:04 AM by Marcus Malinow RSS

    Calculations through a date-bridge table!

      Hello QlikView friends,

       

      I would like to ask a question regarding setting up formulas for a graph when using a date bridge table. Below there is the mapping I have made. It contains the Utilization table with information, attached to its own calendar. Throught a datebridge(link) connected to the canonical calendar. (I will connect more dates to the bridge later)

      IssueTable.png

      Script for this:

      ---------------

      Utilization:

      LOAD ac_registr,

        operator,

        daily_cycles,

          daily_hours,

          tac,

          tah ;

      SQL SELECT ac_registr,

        departure_date,

        daily_cycles,

          daily_hours,

          tac,

          tah

      FROM database;

       

      Datebridge:

      LOAD

      ac_registr

      ,UtilizationDate as CanonicalDate

      ,'UtilizationDate' as DateType

      RESIDENT Utilization;

      ------------------

       

      Now here is the issue, I want to create graphs related to the CanonicalCalendar. The Utilization and Canonical Calendar should have the same values, but as you can see they differ when I set up the same graph. I am aware I might have to use a different expresion, Ive tried many such as:

       

      Sum({<DateType={UtilizationDate}>}daily_cycles)   Althought this gives the same result.

       

      Does anyone have an idea as to what expression to use for the canonical graph to work properly? I has to look up the daily_cycles field somehow, is this even possible?

       

      IssueGraph.png