Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create a function

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

5 Replies
Anonymous
Not applicable
Author

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?

Not applicable
Author

Dear Fuchten,

Many thanks for your reply.

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

Mauriccio

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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