topic How to selecte fields from table in QlikView

How to selecte fields from table

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

We are using SAP Tables (Oracle 11i) for different charts/reports. One thing we wish to understand, whether to select all fields from the table or select minimum requried fields and in due course of time select additional fields whenerever required. As per our understanding we should select only required fields and there after if require, we may select additional required fields.

Re: How to selecte fields from table

tresB — Sat, 01 Mar 2014 04:36:55 GMT

As per our understanding we should select only required fields and there after if require, we may select additional required fields.

Your understanding is right.

Re: How to selecte fields from table

Sat, 01 Mar 2014 04:46:04 GMT

Hi Rahul,

In SAP Tables have many fields in single table so if u select all fields it's take more time.

so we select only our requirement fields.

Re: How to selecte fields from table

Fri, 21 Mar 2014 12:35:45 GMT

Hi Rahul,

I use the ScriptBuilder to generate my SAP conector querys.

This is an example of what you get with it. I added an alias and also a where clause:

[BSEG]: // Accounting Document Segment

Load

BUKRS as BUKRS_BSEG,

[BELNR] as [DocumentNo_BELNR.BSEG],

[GJAHR] as [Fiscal Yr_GJAHR.BSEG],

[LIFNR] as [Vendor_LIFNR.BSEG]

;

SQL Select BELNR BUKRS GJAHR LIFNR from BSEG

where (BUKRS like '0140') or (BUKRS like '0014')

;

STORE * FROM [BSEG] INTO .\BSEG.QVD;

DROP TABLE [BSEG];

Re: How to selecte fields from table

Fri, 21 Mar 2014 13:18:49 GMT

Hi Rahul,

we also use the ScriptBuilder and generate the script with all possible fields. But all the fields not needed at the moment will be commented, so just a few will be loaded.

Advantage: If you need an additional field you just can uncomment the field.