Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

zwyne
Contributor

Convert SQL into Qlikview

Hello everyone,

PFA,

I would like to convert the attached SQL  query into Qlikview

 

 

 

1 Reply
Highlighted
ikarimov
New Contributor III

Re: Convert SQL into Qlikview

hello, qlikview can load this query as is, or you can split this request into several separate ones and let the software bind data by fields:

qualify *;

unqualify Cust_Key,Account_Number;

lake_cust_all:

select * from lake_cust_all;

lake_cust_acc_prod:

left keep (lake_cust_all)

select * from lake_cust_acc_prod;

lake_txn_Summary:

left keep (lake_cust_acc_prod)

select Account_number,Product,NoofTxn from lake_txn_Summary;

 

and third metod - store data or this tables into qvd layer and use it as source in second metod (I advise you to do so)