1 Reply Latest reply: Dec 1, 2014 12:49 AM by Jonathan Dienst RSS

    Regarding multiple scripts in Qlikview

      Hi,

      I have a question regarding scripts in qlikview.

      I am using ContosoRetailDW datawarehouse and this contains 3 fact tables.

      I have created a dashboard for Internet sales and now want to create for reseller sales as well.

      How do I add script in the edit script field? If I load data from FactResellerSales Table, I will have 2 fact tables which is  not correct as only 1 fact table can exist at a time.,

      So how do I proceed?

        • Re: Regarding multiple scripts in Qlikview
          Jonathan Dienst

          Hi

           

          Concatenate the two tables, with a source field to indicate the source. Something like:

           

          Sales:

          LOAD ...,

            'Internet' As Source

          FROM InternetSales;

           

          Concatenate(Sales)

          LOAD ...,

            'Resellers' As Source

          FROM Resellers;

           

          You may need to adjust certain field names if the same content is under a different field name in the Resellers source

           

          HTH

          Jonathan