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!!
