
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oracle SQL to Qlik Sense
I have a Oracle SQL, I need help on converting this query to Qlik Sense
Select Tab0.Month,
Tab0.PRO_cd,
Tab0.Date1,
max(nvl(TSA.var1)) TSA_VAR1,
sum(nvl(TSA.var2)) TSA_VAR2,
max(nvl(TSB.var1,0)) TSB_VAR1,
sum(nvl(TSB.var2,0)) TSB_VAR2,
From
(select distinct month,year, pro_cd, Date1 from ASSP_RPT) TAB0,
(select var1,var2,month,year,pro_cd,Date1 from ASSP_RPT where var3='TSA') TSA,
(select var1, sum(var2) var2, var3,var4,month,year,pro_cd, Date1 from ASSP_RPT where
decode(var3,'z','TSB',var3)='TSB'
group by var1,var2,var3,var4,Month,year,pro_cd,Date1) TSB
where to_char(TAB0.Date1,'yyyymmdd').>= '20230502'
and tab0.RPTYR=2021 and tab0.month=10
and tab0.month=tsa.month(+)
and tab0.year=tsa.year(+)
and tab0.pro_cd=tsa.pro_cd(+)
and tab0.date1=tsa.date1(+)
and tab0.month=tsb.month(+)
and tab0.year=tsb.year(+)
and tab0.pro_cd=tsb.pro_cd(+)
and tab0.date1=tsb.date1(+)
group by tab0.month,
tab0.year,
tab0.pro_cd,
tab0.date1;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I believe in MongoDB you can hide fields from users. Maybe this is the settings that is missing from the user that connects Qlik to your Production Database. You'll have to double check that again with your DBA.
Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I mentioned that I need to convert the above oracle query to Qlik sense. I couldn't understand your reply. I don't have MongoDB.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No conversion should be necessary. You can run Oracle SQL queries from Qlik.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry @Qlik_VA ,
Probably that was an answer from another topic that I put in the wrong place.
Regarding your question, you don't need to convert your queries like @Or said, you can, but you don't need to. You can also move it to a SQL View or Stored Procedure, that also works fine. If you really need to convert it there are many different approaches to do that. Usually, I create one QVD file per used Table and then start the "translation".
Sorry again and let us know if you really need to convert it to Qlik Load Script.
Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com
