9 Replies Latest reply: Nov 6, 2017 8:43 AM by Marko Zadravec RSS

    Sum element from one table divided by time interval from another.

    Marko Zadravec

      Hi,

       

      I have two tables in my qlik sense applications.

       

           [table_one]:

           Load

               [index],

               [Value],

               [CicleId],

               [CicleEnd],

               [CicleStart],

               [time_stamp];

       

            [table_two]:

            LOAD

                [id],

                [diIndex],

                [diStatus],

                [time_stamp];

       

      I try to create table where I would have dimension: CicleId, and measurement sum of diStatus for this cicle period.

       

      What I did is

       

          Sum({<table_two.time_stamp={">=table_one.CicleStart"},table_two.time_stamp={"<=table_one.CicleEnd"},table_two.diIndex={15}>}diStatus)

       

      But What I get is for all rows 0 but in total I get some value (145)

       

      How to fix it