topic Re: SQL Query in Qlikview in QlikView

SQL Query in Qlikview

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

How to write this query in Qlikview:

select ABC_AREACD, ABC_AREAFG,XYZ_DATETRAN, sum(XYZ_NEWTRAN), sum(XYZ_BAL) from fgh_bb_tran

inner join fgh_xx_inv on (ABC_ID = XYZ_ID and XYZ_DATETRAN between '2016-07-01' and '2016-07-20'

and XYZ_FLAGAA='MM' and XYZ_FLAGBB = 'JJ')

inner join Master on (XYZ_IDTRAN = MNO_IDTRAN)

where MNO_Val = 'KK' and xyz_area = 'PP' and ABC_AREACD = 'XX' group by ABC_AREAFG, XYZ_DATETRAN ;

Regards

Eric

Re: SQL Query in Qlikview

Mon, 08 Aug 2016 10:04:58 GMT

Any one....???

Re: SQL Query in Qlikview

sreenivas — Mon, 08 Aug 2016 10:07:35 GMT

You can call directly the SQL Statement.

First add the connection string and then add the below query.

select ABC_AREACD, ABC_AREAFG,XYZ_DATETRAN, sum(XYZ_NEWTRAN), sum(XYZ_BAL) from fgh_bb_tran

inner join fgh_xx_inv on (ABC_ID = XYZ_ID and XYZ_DATETRAN between '2016-07-01' and '2016-07-20'

and XYZ_FLAGAA='MM' and XYZ_FLAGBB = 'JJ')

inner join Master on (XYZ_IDTRAN = MNO_IDTRAN)

where MNO_Val = 'KK' and xyz_area = 'PP' and ABC_AREACD = 'XX' group by ABC_AREACD,ABC_AREAFG, XYZ_DATETRAN ;

Re: SQL Query in Qlikview

Mon, 08 Aug 2016 10:17:16 GMT

I dont want to use Connection String.

I have already fetched the Tables.

Now, I want to write code in Qlikview referring SQL Query.

Re: SQL Query in Qlikview

Mon, 08 Aug 2016 11:11:27 GMT

Need Help.

Re: SQL Query in Qlikview

marjan_it — Mon, 08 Aug 2016 11:24:15 GMT

what do you mean you dont want to use connection string. how did you fetch data from database in to qlikview?!

Re: SQL Query in Qlikview

saimahasan — Mon, 08 Aug 2016 12:25:53 GMT

If you have already fetched the data and stored in qvd then you need to convert your sql query into Qlikview code. Or else if you want to use SQL query then you need to have a connection string and then write your sql code directly

Re: SQL Query in Qlikview

jonathandienst — Mon, 08 Aug 2016 12:33:34 GMT

Its hard to figure out from the information you provided because it is not clear which fields are in which tables. I suggest that you supply a small sample of the tables in an Excel or csv file. You may also want to do some of the filtering when loading the original tables from SQL to simplify and accelerate this operation.