topic SAP BW - How to use Where in Bex query ? in QlikView

SAP BW - How to use Where in Bex query ?

rulohx87 — Mon, 26 Jan 2026 21:26:37 GMT

Hi everybody !

How to use "where" in this query ???

SELECT [ZZFIGL_M02_Q0007]

DIMENSIONS (

[0COMP_CODE], //Sociedad

)

MEASURES (

[00O2TH2JL0XONMTV5YFSBTFXJ], //Período

)

UNITS (

[CURRENCY001.00O2TH2JL0XONMTV5YFSBTFXJ], //CURRENCY001 Período

)

VARIABLES (

[NAME=0S_COCD, SIGN=I, OPTION=EQ, LOW=1010], //Sociedad (opciones selección, opcionales)

[NAME=0S_SEGMENT, SIGN=I, OPTION=EQ, LOW=MTYGA], //Segmento

)

FROM [ZFIGL_M02]

WHERE {[0GL_ACCOUNT] = 0010/611010}; <------------------ ???????

Re: SAP BW - How to use Where in Bex query ?

mats_olin — Fri, 21 Sep 2018 12:27:38 GMT

You can not use WHERE in the Qlik SAP BEx Connector script. You need to use the BEx query variables for any filtering that you want to do. The BEx query variables are configured in SAP Query Designer or HANA Studio if you have a BW Query.

/ Mats

Re: SAP BW - How to use Where in Bex query ?

vijayaganesh_s — Mon, 01 Oct 2018 15:02:35 GMT

Just give a try by loading the Data using resident load and then apply where match() for filtering this may work.

Ex_Table:

Load *

RESIDENT <TABLENAME> WHERE MATCH(FEILD,'VALUE');