Oracle SQL to Qlik Sense

[Qlik_VA]

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;

[marksouzacosta]

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.

[Qlik_VA]

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.

[Or]

No conversion should be necessary. You can run Oracle SQL queries from Qlik.

[marksouzacosta]

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.