topic Re: Query required in QlikView

Query required

Wed, 20 Mar 2013 07:33:16 GMT

Hi,

i have a SQL query which refer to the same table. kindly help me you do i write this query in QV.

SELECT distinct a.icall_no AS call_no,a.machine_no,

DECODE (a.machine_status,

201, 'QUALIFIED CALL',

202, 'QUALIFIED CALL',

203, 'NQ APPROVED CALL',

204, 'NQ APPROVED CALL',

284, 'NM APPROVED CALL'

) AS call_type,

b.region AS region,

b.loc_num AS location

FROM calldetail a, calldetail b

WHERE a.icall_no = b.icall_no

AND a.status = 38

AND a.call_date >= '03-aug-2009'

AND a.call_date < '10-aug-2009'

AND a.call_no <> b.call_no

Anonymous — Wed, 20 Mar 2013 07:40:58 GMT

Does it work if you just wrap it with SQL and ; ?

SQL

SELECT distinct a.icall_no AS call_no,a.machine_no,

...

WHERE a.icall_no = b.icall_no

AND a.status = 38

AND a.call_date >= '03-aug-2009'

AND a.call_date < '10-aug-2009'

AND a.call_no <> b.call_no

;

kaushiknsolanki — Wed, 20 Mar 2013 09:28:45 GMT

HI,

Try this.

DATA:

Load region,loc_num,.icall_no, call_no from calldetail.qvd(qvd);

join

Load icall_no ,.machine_no,

if(match(machine_status,'201','202'),'QUALIFIED CALL',

if(match(machine_status,'203','204'),'NQ APPROVED CALL',

if(match(machine_status,'284'),'NM APPROVED CALL'))) as call_type

From calldetail.qvd(qvd)

where Status = 38 and call_date >= makedate(2009,08,03) and call_date < makedate(2009,08,10)

and not exisits(call_no,call_no);

Regards,

Kaushik Solanki