Create a function

[#1]

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

[Anonymous]

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?

[#3]

Dear Fuchten,

Many thanks for your reply.

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

Mauriccio

[#4 · Accepted solution]

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:)

[#5]

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

[#6]

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