topic Re: HOW TO CONVERT SQL QUERY INTO QLIKVIEW SCRIPT ? in QlikView

HOW TO CONVERT SQL QUERY INTO QLIKVIEW SCRIPT ?

pkpandey — Mon, 26 Jan 2026 16:26:21 GMT

Hi All

Please Help me in above of the following query

case when rcty.CUST_TRX_TYPE_ID in (select CUST_TRX_TYPE_ID

from ra_cust_trx_types_all rctt,

fnd_lookup_values flv

where rctt.name = flv.meaning

and lookup_type = 'XXSNARAINV'

and tag = 'COMM')

then (select aci1.billing_date from

ar_cons_inv_all aci1,

ar_cons_inv_trx_all actrx1,

ra_customer_trx_all ct1

where actrx1.cons_inv_id = aci1.cons_inv_id

and aci1.customer_id = hcc.cust_account_id

and ct1.customer_trx_id = actrx1.customer_trx_id

and ct1.CUST_TRX_TYPE_ID in (select CUST_TRX_TYPE_ID

from ra_cust_trx_types_all rctt,

fnd_lookup_values flv

where rctt.name = flv.meaning

and lookup_type = 'XXSNARAINV'

and tag = 'COMM')

and rownum =1)

else ct.trx_date

end trx_date,

Re: HOW TO CONVERT SQL QUERY INTO QLIKVIEW SCRIPT ?

Wed, 03 Dec 2014 21:05:57 GMT

Typically, all you need in order to port a SQL query into qlikview is put it after a connection string in the script.

Or, create a SQL view in sql studio and read from that...

Don't forget to put the

Load *;

Sql select...

-David