Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

SQL Functions


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

Tags (1)
3 Replies

Re: SQL Functions

New Contributor III

Re: SQL Functions

1. If that function is simple then Call the function as normal sql statement from Qlik View as below.
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

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


Community Browser