Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor

Where clause for SAP Report Connector

Hi,

I am using SAP Report Connector to load a report. I tried searching but couldn't find a post to about Where clause in SAP report connector. I tried putting in at LOAD statement but my resulting qvd is empty.

E.g.

LOAD [Field9_Funds Ctr]

Where [Field9_Funds Ctr] = 'S01001';

My script as follows:

[RFFMED_DRILLDOWN]:

Load

[Field0_Doc Year],

[Field1_Entry Docu],

[Field2_Line],

[Field3_Version],

[Field4_Doc. Type],

[Field5_Process],

[Field6_Year],

[Field7_Budget Type],

[Field8_Fund],

[Field9_Funds Ctr],

[Field10_Cmmt Item],

[Field11_Funded Program],

[Field12_Amount LC],

[Field13_C];

Select SAPREPORT (REPORT (RFFMED_DRILLDOWN), VARIANT (QLIK), ROWS_PER_RECORD (1), FIELD_DELIMITER_POSITIONS (0, 9, 20, 27, 35, 45, 56, 61, 76, 81, 91, 101, 117, 134, 138), SKIP (P (0, "┌──────────────┬─────┬──────┬────────┐"), P (0, "!Sort criteria !Ascdg!Descnd!Subtotal!"), P (0, "├──────────────┼─────┼──────┼────────┤"), P (0, "!FM Area       !  X  !      !        !"), P (0, "!Document Year !  X  !      !        !"), P (0, "!Entry Document!  X  !      !        !"), P (0, "└──────────────┴─────┴──────┴────────┘"), P (0, "┌───────────────┬─────────┐"), P (0, "!Data statistics!Number of!"), P (0, "├───────────────┼─────────┤"), P (0, "!Records passed !    1,412!"), P (0, "└───────────────┴─────────┘"), P (0, "FM area         1000"), P (0, "Currency        SGD"), P (0, "Budget Category Payment"), P (0, "┌────────┬──────────┬──────┬───────┬─────────┬──────────┬────┬──────────────┬────┬─────────┬─────────┬───────────────┬────────────────┬───┐"), P (0, "├────────┼──────────┼──────┼───────┼─────────┼──────────┼────┼──────────────┼────┼─────────┼─────────┼───────────────┼────────────────┼───┤"), P (0, "└────────┴──────────┴──────┴───────┴─────────┴──────────┴────┴──────────────┴────┴─────────┴─────────┴───────────────┴────────────────┴───┘")), HEADER (P (0, "!Doc Year!Entry Docu!Line  !Version!Doc. Type!Process   !Year!Budget Type   !Fund!Funds Ctr!Cmmt Item!Funded Program !       Amount LC!C  !")));

Store * from [RFFMED_DRILLDOWN] into QVD\RFFMED_DRILLDOWN_QLIK_SG_TEST.QVD;

Drop Table [RFFMED_DRILLDOWN];

EXIT Script;

1 Solution

Accepted Solutions
Highlighted

Re: Where clause for SAP Report Connector

Can you try here, The variant might doesn't consider as preceding load. I am assuming you are not the person who created this variant. Try this

[RFFMED_DRILLDOWN]:

Load

[Field0_Doc Year],

[Field1_Entry Docu],

[Field2_Line],

[Field3_Version],

[Field4_Doc. Type],

[Field5_Process],

[Field6_Year],

[Field7_Budget Type],

[Field8_Fund],

[Field9_Funds Ctr],

[Field10_Cmmt Item],

[Field11_Funded Program],

[Field12_Amount LC],

[Field13_C] Where [Field9_Funds Ctr] = 'S01001'; // Here, S01001 Case Sensitive

Select SAPREPORT ( ......

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

4 Replies
Highlighted

Re: Where clause for SAP Report Connector

Can you try here, The variant might doesn't consider as preceding load. I am assuming you are not the person who created this variant. Try this

[RFFMED_DRILLDOWN]:

Load

[Field0_Doc Year],

[Field1_Entry Docu],

[Field2_Line],

[Field3_Version],

[Field4_Doc. Type],

[Field5_Process],

[Field6_Year],

[Field7_Budget Type],

[Field8_Fund],

[Field9_Funds Ctr],

[Field10_Cmmt Item],

[Field11_Funded Program],

[Field12_Amount LC],

[Field13_C] Where [Field9_Funds Ctr] = 'S01001'; // Here, S01001 Case Sensitive

Select SAPREPORT ( ......

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Highlighted
New Contributor

Re: Where clause for SAP Report Connector

Thanks, it works. Weird that i tried previously it can't...

Highlighted

Re: Where clause for SAP Report Connector

Could be Even this case i doubt why Preceding load won't consider while loading from SAP. Will check this and update you

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted

Re: Where clause for SAP Report Connector

JFU - It's working even pull data from SAP

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)