Connected to a Library using Select , Need help with Statements

[Bubskim]

Hello!!!

I am stuck....

I have done the following in qliksense:

LIB CONNECT TO 'database.123'; (working)

Select * from testing_file (working)

Where _DATE = TRUNC( CAL_date(sysdate, 1, '-'))
AND _ID = 1    (working)

I NEED TO ADD THIS AS WELL AND I CANNOT GET IT TO WORK WITH THE ABOVE. PLEASE HELP ME WITH SEQUENCE.

HELP ME MAKE THIS INTO IF STATMENT FOR QLIKSENSE PLEASE!!

abs(tx.C1_N) as 1Volume,

                 case when tx.C1_CD = 'U' then tx.C1_CD

                  when tx.C2_CD = 'U' then tx.C1_CD

                  else tx.C1_CD end as Volcode,

                 case when tx.C1_CD = 'U' then abs(tx.C1_N)

                  when tx.C2_CD = 'U' then abs(tx.C2_N)

                  else abs(tx.C1_N) end as VolAmt,

Thanks!!