Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
how to conver pl-sql logic into qlik view script please.
Hi P Kumar,
The official help site contains many important and helpful content.
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.
Create a stored procedure in server then use the following command in qlik data load editor:
SQL Execute <storedProc>;
G.
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.
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.
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!
Can you please give example how we can replace this with variables?
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.