Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to only bring the records that have scale quantity 1 (from SAP). The code below is giving me this error message:
Load
[KNUMH] as [Cond.record no],
[KSTBM] as Scale_Quantity,
[KBETR] as [Amount LC1];
SQL Select KBETR KSTBM KNUMH from KONM
where [KSTBM]=1 ;
Writing [KSTBM]='1' is throwing the following error. Please help.
Have you tried running the same query outside of QlikView?
Do not you need comma?
SQL Select KBETR , KSTBM , KNUMH from KONM
where [KSTBM]=1 ;