Discussion Board for collaboration on QlikView Scripting.
I have 4 different qvs files that I concatenate to one big table.
I have to add calculated field info into the resulting tabel.
What is best to do:
Text(Field1) AS Customer
FROM [$(vpath.QVDSource)InvoiceList 2012.qvd] (qvd);
Concatenate Load *,
FROM [$(vpath.QVDSource)InvoiceList 2013.qvd] (qvd);
if Amount > 100, high, low AS Type
(working with .temp qvs does not word except as I add an additional calculated field... )
could I add this step
'if Amount > 100, high, low AS Type' to each load? What should be the correct syntax in the second case:
not using the 'temp' tabel and add the calculated field to each concat load...
if Amount > 100, high, low AS Type;
Is this correct syntax the achieve the same result?
I would do the following:
Set vConcatenate = ;
For vYear = 2012 to 2013
Text(Field1) as Customer,
if (Amount > 100, 'high', 'low') as Type
FROM [$(vpath.QVDSource)InvoiceList $(vYear).qvd] (qvd);
Set vConcatenate = Concatenate;