topic help me how to write given MY sql quiery in QV in QlikView

help me how to write given MY sql quiery in QV

balasundaram — Thu, 15 May 2014 11:48:16 GMT

SELECT TC.Name,TM.Type,TM.width,TC.N2NAME,TC.ACTUALNAME,TC.APORTNAME,TC.ZPORTNAME, TC.CircuitType ,TC.C2CTypeName,TC.C2CBandwidth,TM.Coverage, TM.CITY,

Count(1) CNT,SEQ,USAGE
FROM
Uc.master as TM,
UC.tmcircuit AS TC
GROUP BY Name,TM.Type,
N2NAME,ACTUALNAME,TC.APORTNAME,TC.ZPORTNAME, CircuitType ,
C2CTypeName,TC.C2CBandwidth,TM.Coverage, TM.CITY,SEQ,USAGE

my problem is COUNT function..........

Re: help me how to write given MY sql quiery in QV

fernando_tonial — Thu, 15 May 2014 12:04:07 GMT

Put Before SQL

SQL SELECT 
  TC.Name,
  TM.Type,
  TM.width,
  TC.N2NAME,
  TC.ACTUALNAME,
  TC.APORTNAME,
  TC.ZPORTNAME, 
  TC.CircuitType,
  TC.C2CTypeName,
  TC.C2CBandwidth,
  TM.Coverage,  
  TM.CITY,
  Count(1) CNT,
  SEQ,
  USAGE 
FROM 
  Uc.master as TM,
  UC.tmcircuit AS TC 
GROUP BY  TC.Name,
  TM.Type,
  TM.width,
  TC.N2NAME,
  TC.ACTUALNAME,
  TC.APORTNAME,
  TC.ZPORTNAME, 
  TC.CircuitType,
  TC.C2CTypeName,
  TC.C2CBandwidth,
  TM.Coverage,  
  TM.CITY,
  SEQ,
  USAGE;

Best Regards.

Tonial.

Re: help me how to write given MY sql quiery in QV

balasundaram — Thu, 15 May 2014 12:31:11 GMT

i need to write that procedure in the form of QV script. and also i need to load that data from "master.qvd" and "tmcircuit.qvd"

Re: Re: help me how to write given MY sql quiery in QV

fernando_tonial — Thu, 15 May 2014 13:02:32 GMT

Try this:

Master:
LOAD *, 1 AS CNT FROM master.qvd (qvd);

Inner Join (Master)
LOAD * From tmcisrcuit.qvd(qvd);

Best Regards.

Tonial.