1 Reply Latest reply: Dec 14, 2012 2:44 AM by Kabilan Kumarasamy RSS

    use clause where in Exprssion

      hi everyone,

      i am  a beginner , and i trying to discover the use of the 'expression' in qlikView.

      i have two table:

      [table 1:

      resource_id,

      task_id,

      ETC,

      conso,

      date as date1]

      [table2:

      resource_id,

      project_id,

      dispo,

      date as date2]

      for not havaing loops in my modele i changed the name of the date field "date" and "resource id"

       

      my problem is i want

      to: sum(conso)+sum(ETC)+[sum(dispo) where date equal to date in my dimention (date1) and project_id = the selected project in my list box]