Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

jduenyas
Contributor III

Data Load with customer function

Hi All
Is it possible to call a custom function which I have built into the VB Module to evaluate elappsed time between dates into a field at Load time?
Also, is it possible to use the function in an expression?
LOAD
ProjectEngineerID,
EmailReceivedOn,
QuotedOn,
TimeCard(EmailReceivedOn,QuotedOn) AS ElapsedTime;
SQL SELECT *
FROM QDB.dbo.vuPESTATS;

The TimeCard is the cutome function which I have built. (Sample file is attached)

Running the function in the VB Module works OK but no values are returned during the load time.
Thanks
Josh
1 Reply
Employee
Employee

Re: Data Load with customer function

This is an old post with no reply. For any users searching for an answer to this in future, the answer is Yes. Check out this thread http://community.qlik.com/message/67282#67282

Community Browser