HOW TO CONVERT SQL QUERY INTO QLIKVIEW SCRIPT ?

[pkpandey]

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,

[#2]

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