Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
balasundaram
Contributor II

help me how to write given MY sql quiery in QV

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..........

3 Replies
fernando_tonial
Valued Contributor

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

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.

balasundaram
Contributor II

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

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"

fernando_tonial
Valued Contributor

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

Try this:

Master:

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

Inner Join (Master)

LOAD * From tmcisrcuit.qvd(qvd);

Best Regards.

Tonial.

Community Browser