Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

olguita2014
Contributor

SAP

Hi,

I have two tables on SAP, VBRK and VBRP. And I need to filter only one year, but the date only has this table: VBRK

Please help me

Tags (1)
1 Reply
lcontezini
Contributor

Re: SAP

you can link (or join) the tables with the VBELN field, like:

VBRK:

LOAD

     VBELN AS DOCUMENT_NUMBER,

     GJAHR AS YEAR

FROM VBRK;

VBRP:

LOAD

     VBELN AS DOCUMENT_NUMBER,

     FKLMG AS QUANTITY

FROM VBRP;


When you select YEAR, it will select data from both tables. If you want to load only one year, I'd suggest you do the following:


VBRK:

LOAD

     VBELN AS DOCUMENT_NUMBER,

     GJAHR AS YEAR

FROM VBRK

WHERE GJAHR = '2018';

LEFT JOIN(VBRK)

LOAD

     VBELN AS DOCUMENT_NUMBER,

     FKLMG AS QUANTITY

FROM VBRP;


something like this.

Community Browser