Discussion Board for collaboration on QlikView Scripting.
I have a code like this
Now i have to give joint where condtion??? should I use brackets??
Go to Solution.
if for joint where you mean condition on fields of Q and P
you need another resident load
NoConcatenate load *
where x=1 and a=20 or b='cc';
resident P where "Field"= "Value";
try like this
Try like this
Load * Inline [ Id,Amount1,1002,2003,-1004,-300];Final:LoadIf(Amount >= 0,Amount,0) as CreditAmount,If(Amount <= 0, Amount,0) as DebitAmountResident TestData where Id = '1';
First of all, since there is no matching columns between Table P and Q, your join will result in a table will all 6 columns: x, y, z, a, b, c. This implicit outer join is equal to concatenate.
Regardless, you may specify the where condition as follow
LOAD a, b, c
WHERE a='condition A'
LOAD x, y, z
WHERE x='condition X'
Can you close this thread by selecting appropriate answers