topic Re: mapping sql statement in qlikview script in QlikView

mapping sql statement in qlikview script

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

Can any one please explain me what does "sql select" do in qlikview ?

I'm editing one qvw file where I see statements like following

Colg_Stud:

mapping sql select rtmt_id,rtmt_name from Colg_Stud;

I tried checking on net but could not get anything so thought of asking here.

Thanks in advance!!!

Re: mapping sql statement in qlikview script

kaushiknsolanki — Mon, 11 Nov 2013 10:06:16 GMT

Hi,

Sql is used when you want to fetch data from database.

The help says.

The SQL statement allows you to send an arbitrary SQL command through an ODBC or OLE DB connection.

Regards,

Kaushik Solanki

Re: mapping sql statement in qlikview script

jagan — Mon, 11 Nov 2013 10:15:06 GMT

Hi Kavita,

The below statement loads rtmt_id and rtmt_name from SQL table and it loads it into qlikview as Mapping Load table. Generally mapping load is used to get value by passing the key(ID) of the value using ApplyMap(). Please check example below

Colg_Stud:

mapping sql select rtmt_id, rtmt_name from Colg_Stud;

Example from Qlikview Help file:

Examples:

// Assume the following mapping table:

map1:

mapping load * inline [

x, y

1, one

2, two

3, three ] ;

ApplyMap ('map1', 2 ) returns ' two'

ApplyMap ('map1', 4 ) returns 4

ApplyMap ('map1', 5, 'xxx') returns 'xxx'

ApplyMap ('map1', 1, 'xxx') returns 'one'

ApplyMap ('map1', 5, null( ) ) returns NULL

ApplyMap ('map1', 3, null( ) ) returns 'three'

Re: mapping sql statement in qlikview script

Mon, 11 Nov 2013 10:16:19 GMT

Hi Kaushik,

What does mapping key word do here ??

Thanks

Re: mapping sql statement in qlikview script

Mon, 11 Nov 2013 10:23:16 GMT

Thank a lot jagan