topic Re: Error Simple If statement in QlikView

Error Simple If statement

Ping-Guererro — Wed, 25 Nov 2020 16:16:04 GMT

HI Guys, May i know what is the problem in my if statement? I'm trying to get the total adj_amt per dmd_flow_id (INDEM, PRDEM,PNDEM)

LDA:
LOAD 
Account_Number,
Payment_date,
dmd_flow_id,
adj_amt,
IF(dmd_flow_id='INDEM',SUM(adj_amt)) as Interest_collected;

SQL SELECT Account_Number,
Payment_date,
dmd_flow_id,
adj_amt
FROM `payment table`;

Thank you

Re: Error Simple If statement

zzyjordan — Thu, 10 Jan 2019 03:11:33 GMT

Hi,
Can you try below script and let me know whether it works or not?
LDA:
LOAD
Account_Number,
Payment_date,
dmd_flow_id,
adj_amt;

SQL SELECT Account_Number,
Payment_date,
dmd_flow_id,
adj_amt
FROM 'payment table';

left Join(LDA)
Load dmd_flow_id, sum(adj_amt) as Interest_collected
resident LDA
where dmd_flow_id='INDEM'
Group by dmd_flow_id

ZZ

Re: Error Simple If statement

Ping-Guererro — Thu, 10 Jan 2019 06:26:51 GMT

Hi Sir, when i tried your code the error show: Field 'dmd_flow_id' not found.

Thank you

Re: Error Simple If statement

zzyjordan — Thu, 10 Jan 2019 06:46:16 GMT

try this

LDA:
LOAD
Account_Number,
Payment_date,
dmd_flow_id,
adj_amt;

SQL SELECT Account_Number,
Payment_date,
dmd_flow_id,
adj_amt
FROM 'payment table';

NoConcatenate

Final_LDA:
Load *
Resident LDA;

left Join(Final_LDA)
Load dmd_flow_id, sum(adj_amt) as Interest_collected
resident LDA
where dmd_flow_id='INDEM'
Group by dmd_flow_id;

drop Table LDA;

Re: Error Simple If statement

sunny_talwar — Thu, 10 Jan 2019 12:45:38 GMT

What exactly are you trying to do? Can you explain this with an example?