Qlik Community

Ask a Question

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rulohx87
Contributor III
Contributor III

SAP BW - How to use Where in Bex query ?

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}; <------------------   ???????

1 Solution

Accepted Solutions
mats_olin
Employee
Employee

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

View solution in original post

2 Replies
mats_olin
Employee
Employee

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

View solution in original post

vijayaganesh_s
Partner
Partner

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

Like

Ex_Table:

Load *

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