2 Replies Latest reply: Aug 12, 2011 2:53 AM by Jagan Nalla RSS

    how to make selection between two fact tables??

    Sushil Kumar

      Hi All,

       

       

      My problem senario is...

       

       

      i have to fact tables lets say A_FCT and B_FCT and other are dimention tables say ( L_DIM, P_DIM, O_DIM ) which are common to both fact tables.. fields in A_FCT and B_FCT are same but differ in data...

       

      I want to make a report in such a way so that there may be a selection tab or field between these to fact tables.. means when ever a  user select fact table A_fct, all the reports and chart will be manipulated from A_fct table and if the user select B_FCT then all the chart/reports manuplates on b_fct table...

       

       

       

      Please help me out how to load these table in qlikview environment such that they full fill my requirement... what would be the structure of loading..

       

      Thanks..

        • how to make selection between two fact tables??
          Kaushik Solanki

          Hi,

           

              If the Number of columns( Fields) abd the name of the Columns(Fields) in Fact_A and Fact_B are same then you can try this way.

           

              Fact:

              Load

                   Field1,

                   Field2,

                   'FACT A' as Fact

              From Fact _A;

           

              Load

                 Field1,

                 Field2,

                 'FACT B' as Fact

              From Fact_B;

           

              This will combine both the Fact tables into one Fact.

           

              Now you will have a new field Called Fact where you will have two values. i.e Fact A and Fact B

           

              So when ever you select Fact A, all data will be filter according to Fact A data. and vice versa.

           

              Hope you got what i mean to say.

           

              Hope this helps.

           

          Regards,

          Kaushik Solanki

            • how to make selection between two fact tables??
              Jagan Nalla

              Hi,

               

              A_FCT:

                   Load field1,field2,L_DIM_field1, P_DIM_field1,O_DIM_field1

                   from A_FCT;

               

              QUALIFY *;

              UNQUALIFY  L_DIM_field1, P_DIM_field1,O_DIM_field1 ;

              B_FCT:

                   Load field1,field2,L_DIM_field1, P_DIM_field1,O_DIM_field1

                   from A_FCT;

              UNQUALIFY *;

               

              - Now you can generate the reports based on different fact tables. Form A_FCT table take fields directly to the objects. But, for B_FCT the fields look like this B_FCT.field1,B_FCT.field2,......

               

              But the dimension fields look same for the both tables.

               

              Hope this helps you..