topic Re: SQL Functions in QlikView

SQL Functions

Mon, 16 Feb 2015 09:09:21 GMT

Hi,

I am new to qlikview and I am working in cognos for last 2 years. I came accross a situation and I am unable to find a solution for that.

I want to convert EPOCh dates to date format. we have a function in oracle database which we use in cognos to do the same.

Is it possible to do that in QlikView? If not, Is there any other way to achieve this?

Thanks In Advance

Re: SQL Functions

marcus_sommer — Mon, 16 Feb 2015 16:44:02 GMT

Have a look on these various blog-postings: http://community.qlik.com/search.jspa?q=date+format&author=%2Fpeople%2F4003&type=post

- Marcus

Re: SQL Functions

Anonymous — Thu, 05 Mar 2015 06:22:45 GMT

Hi,
1. If that function is simple then Call the function as normal sql statement from Qlik View as below.
QVtable:
Load *;
select * from [DB]..StringToList('1:2',':');
2. Else Use stored procedure to call the function and execute the procedure in Qlik View

Re: SQL Functions

hic — Thu, 05 Mar 2015 07:14:04 GMT

If this is a UNIX date/time, you should use the method described here: transform UNIX date format to ASCII /Windows format

HIC