topic Re: SQL Stored Procedure into QlikView in QlikView

SQL Stored Procedure into QlikView

priyav24 — Sun, 30 Jun 2013 08:18:19 GMT

Hello Everybody,

I have used stored procedure for my qlikview dashboard,

Checking --Open database in read and write mode in the settings tab of the Editscript

and Used

Query

SQL

EXECUTE

[AUJANX3].[usp_sage_OutReg] '1 dec 2012','31 dec 2012','0','ZZZZ' ,'0','ZZZZ','0','ZZZZ'

In this stored procedure ,

I have a field ACCDAT_0 is the datefield in a string format

I want that to modify as Date(ACCDAT_0 ) as Date

Is it possible in Qlikview??

Thanks in Advance!!!

Priya

Re: SQL Stored Procedure into QlikView

Gysbert_Wassenaar — Sun, 30 Jun 2013 09:04:44 GMT

You can use a preceding load to create the Date field:

LOAD *, date#(ACCDAT_0, 'D MMM YYYY') as Date;

SQL

EXECUTE

[AUJANX3].[usp_sage_OutReg] '1 dec 2012','31 dec 2012','0','ZZZZ' ,'0','ZZZZ','0','ZZZZ';

Make sure you use specify the right date format. 'D MMM YYYY' is an example based on the date strings you passed to the stored procedure. If the stored procedure returns strings in a different format then you'll have to change the format in the date# function to that format.

Re: SQL Stored Procedure into QlikView

priyav24 — Sun, 30 Jun 2013 09:10:28 GMT

Thanks Gysbert..:)