Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

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?

1 Reply
MVP
MVP

Re: Regarding multiple scripts in Qlikview

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser