Discussion Board for collaboration on QlikView Scripting.
I have a data set reporting the Sales:
[Sold to Party Number],
[Sold to Party Name],
[Sale order Number],
[Unit of Measure],
[Ship to Party],
[Ship To Name],
[Good Issue Date],
[Invoice date] as "Date",
[Billing Document Currency],
left(subfield(FileName(),'_',1),12) as "Sales_Org"
FROM [lib://Analisi Dati/*.xls]
(biff, embedded labels, table is Format$);
Invoice dimension contains only a 10 digit number.
I have created another data set with Invoice which I would like to exclude in the loading phase.
The new Data set has only one dimension:
I know is a very basic question but I'm new to Qlik Sense and I don't know how to progress.
Thank you in advance for your help and suggesiton.
Go to Solution.
To my understanding i guess you dont need the invoice numbers that are in the second table
if that is the case!
May be this
'X' as [Deletion Flag]
Can you explain few values for Invoice from Sales Table and Data set then come up with which values you want to exclude?
You could exclude them with a where-exists-clause like the following (a bit simplified here):
load * Invoice from ExcludingSource;
load * from TransactionSource where not exists(Invoice);
Thank you for the help Aar and Marcus.