Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pawwy1415
Creator III
Creator III

how to convert pl-sql logic into qlik

Hi,

how to conver pl-sql logic into qlik view script please.

7 Replies
undergrinder
Specialist II
Specialist II

Hi P Kumar,

The official help site contains many important and helpful content.

Home ‒ Qlik Sense

Maybe you don't have to convert logic, if you are send sql to server directly, or stored procedure get back with data.

Please do not duplicate the threads

how to convert pl-sql logic into qlik logic

It makes harder to follow the discussion.

G.

undergrinder
Specialist II
Specialist II

Create a stored procedure in server then use the following command in qlik data load editor:


SQL Execute <storedProc>;

SQL ‒ Qlik Sense

G.

pawwy1415
Creator III
Creator III
Author

Hi,

Thanks for reply. 1st thread is not repeated and 2nd it's not possible not convert into Store procedure.. Is there anyway if I can directly load this query into QVD and then use it.. Can you make relevant changes which need to do please.

undergrinder
Specialist II
Specialist II

Hi Kumar,

Sorry, I didn't noticed the attachments are different.

I skim the Query1 and I noticed there is a @Prompt command in there.

eg.:

@Prompt ('1. Enter Start Date of Range in Fomat DD-MON-YYYY','A',,MONO,FREE),'DD-MON-YYYY')

I think these commands should be replaced e.g. with variables.

G.

undergrinder
Specialist II
Specialist II

And try elaborate the SQL in Qlik topic, start with an easy select * from Table, then you will be able to

create a beutyful and professional queries

Good luck!

pawwy1415
Creator III
Creator III
Author

Can you please give example how we can replace this with variables?

undergrinder
Specialist II
Specialist II

Hi,

Quer1 contains the following snippet:

WHERE STDATE BETWEEN TO_DATE(@Prompt ('1. Enter Start Date of Range in Fomat DD-MON-YYYY','A',,MONO,FREE),'DD-MON-YYYY') AND

TO_DATE(@Prompt ('2. Enter End Date of Range in Fomat DD-MON-YYYY','A',,MONO,FREE),'DD-MON-YYYY')

The where clause is waiting two dates as input.

Declare two variable e.g. startdate and enddate

let startdate = date('2016-01-01','YYYY-MM-DD');

let enddate = date('2016-01-31','YYYY-MM-DD');

And modify the where clause:

WHERE STDATE BETWEEN '$(startdate)' AND '$(enddate)'

Hope this helps.

G.