Qlik subroutine parameters – passing arguments by reference and by value

Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about passing arguments to Qlik subroutine parameters:

This proved to be a harder question than expected, as only a single person got the right answer. Well done Vaibhav Sharma!

The correct answer is B: lines 4 and 8 both show the value 8

How variables are stored in memory

To explain the difference between passing by value and passing by reference we first need some basic knowledge of how memory works. We’ll use a simplified explanation for this, which should be enough to understand the basic concept.

You can consider memory as a collection of blocks that can hold data. Each block has an address, numbers 1 through 60in the illustration below. When you store a value into a variable, your operating system will automatically decide where to place this in memory. In the illustration below, the value we’ve set for the vNumber variable is stored at memory address 32.

Pass by value

When we pass by value, the value is copied to another location in memory. In the illustration below a copy of the value is placed at memory address 24. Subsequent operations, such as the multiplication in the subroutine, are performed on the copy. The original value is left untouched.

Pass by reference

When we pass by reference, we pass a reference to the memory address of the variable. What this means in our example is that both vNumber and vInput now reference the same memory space and value within that space.

Any operation that is performed to pInput updates the same value that is being referenced by vNumber, and vice versa. This explains the behavior that we see in the example script.

Passing by value vs passing by reference in Qlik

So how can we fix this script to ensure that vNumber is passed by value? By using Dollar-sign expansion! This passes the value of the variable to the subroutine, rather than a reference to the variable. See the updated script below, with a change on line 9.

That’s it for this week. And remember:

Are these questions too easy for you?

If these questions are too easy for you, then you may be ready for the Masters Summit for Qlik.

At the Masters Summit for Qlik, we take your Qlik skills to the next level in 3 days with deep dives about:

• Qlik Data Modelling
• Qlik Scripting
• Set Analysis and Advanced Aggregations
• Solution Architecture & Performance
• Effective Visualizations
• Performance Tuning
• Qlik Sense integration

The courses are taught by Qlik veterans Rob Wunderlich, Oleg Troyanksy, Bill Lay, Nick Webster and Bitmetric’s Barry Harmsen. Together, this team brings almost 75 years of Qlik experience and has implemented hundreds of successful projects.

You can find more information and registration on the Masters Summit for Qlik website, or check out a photo impression of the previous edition in Madrid.

See you next week!

• If you have suggestions for questions, we love to hear from you via WhatsApp or at info@bitmetric.nl
• If you’re enjoying these questions and want to work on stuff like this every day (but a bit more challenging), we’re always on the lookout for new colleagues. Check our job openings here.
• For more of these brain teasers, check out our archive of Qlik certification questions and answers.
• Want to stay up to date about everything Qlik? Then sign up for our newsletter at the top of this page.