1 Reply Latest reply: Dec 3, 2014 4:05 PM by David Cohen RSS

    HOW TO CONVERT SQL QUERY INTO QLIKVIEW SCRIPT ?

    Pradeep Kumar Pandey

      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,