Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jonathandienst
Partner - Champion III
Partner - Champion III

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