topic Re: Parameteized Variables in QlikView

Parameteized Variables

kwnkhn — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a document using variables with parameters throughout.

The parameters are $1,$2,$3,$4 and $5.

I would like to know the values assigned / passed to parameters $1 and $2.

How would I go about this?

Thank you.

Re: Parameteized Variables

Mauritz_SA — Tue, 19 Feb 2019 11:42:04 GMT

Hi there

Add a KPI object and just put $($1) in it. The $() part will 'extract' the value of the variable. You can do the same for the other four variables.

If you don't need to see them in the dashboard you can just click on the x= button in the bottom left of the screen in edit mode and find your variables. Their values will be in the Definition column.

Regards,

Mauritz

Re: Parameteized Variables

rwunderlich — Tue, 19 Feb 2019 12:30:54 GMT

You will need to scan for use of the variable that uses the parameter. For example, you make have a variable named "Add2" that is defined as:

RangeSum($1, $2)

The variable will be used in charts like:

$(Add2(3, 6))

In this case "3" will be passed to $1 and "6" to $2.

So..if you want to see what kind of values are being used, scan for the use of the parameterized variable in expressions. You can find the variable usage in either the Expression Overview or Document Analyzer.

-Rob