Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Problem in Select Query

Dear Experts,

AUSP:

LOAD

ATINN,

ATWRT,

OBJEK;

SQL SELECT ATINN ATWRT OBJEK FROM AUSP

WHERE ATINN = 'MKTG_ACCT_MGR1';

In above SQL Select query 0 lines fetched. In SAP MKTG_ACCT_MGR1 is exists.

However, it shows 0 lines.

Kindly suggest the same.

Thanks and Regards

Amol Khochare

1 Reply
Not applicable

Re: Problem in Select Query

Try loading everything into the QV table - then check in that loaded data whether MKTG_ACCT_MGR1 exists.

If it does copy the output value and use it in the WHERE clause of the SQL query, or, resident load AUSP1 with the criteria to only pull through the MGR1 data.