Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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