topic AW:Re: Create a function in QlikView

Create a function

Tue, 01 Dec 2009 20:36:52 GMT

Dears,

I want to create a function/ procedure/ subrutine in qlikview scripts. Is that possible??, I mean, for instance, if I want to validate a verification digit which it has an especific algorithm, How can I create a qlikview function in order to provide an entry and then receive a output.

Many thanks in advance.

Mauriccio

Create a function

Anonymous — Tue, 01 Dec 2009 20:50:44 GMT

You can use macro's in Qlikview ...

But you can also do some checking in the expresions used.

As I understand you want the data of the table to be checked?

Create a function

Tue, 01 Dec 2009 21:14:41 GMT

Dear Fuchten,

Many thanks for your reply.

Positive, I want to check some data in a table. How can I create a macro?

Mauriccio

AW:Re: Create a function

Tue, 01 Dec 2009 21:54:30 GMT

Hi,

write a VB-Function and use it in a load. See attached Application.

You have to write the Functions and save the application before you can use it.

Have Fun with QV

Alex:)

AW:Re: Create a function

Wed, 02 Dec 2009 02:55:42 GMT

Dear Alexander,

Many thanks for your kind help.

What is the function PLUS1??, I have looked for it on the functions menu, however I couldn't find it.

I have create a macro on an excel file now, and I want it to be on my qlickview file, How do I do that??

Many thanks again

Mauricio

AW:Re: Create a function

Wed, 02 Dec 2009 07:53:36 GMT

Dear Alexander,

Never mind. I have already found that PLUS1 is a macro made by you on the tools section.

Many thanks in advance.

Mauriccio