5 Replies Latest reply: Sep 9, 2015 5:24 AM by arjun rao RSS

    Joining with two key columns

    kumar avisakula

      Hi,

       

      I am new Qlikview

       

      I have a fact table and dimension table. Dim table should join fact table with two key columns.

       

      Like

      Fact_fla table is having keys like below

      fla_assgn_to_key

      fla_assgn_from_key

      revenue

      fla_status_count

      .

      .

      .

       

      And Dimension table

      Dim_con

      con_key

      .

      .

      I want to join like

       

      select * from fact_fla,Dim_con

      where fla_assgn_to_key=con_key

      and fla_assgn_from_key=con_key

       

      Please help me on this scenario.

       

      Regards,

      Kumar