topic Parameterised variable as a string in QlikView

Parameterised variable as a string

peter_turner — Mon, 06 Oct 2014 10:17:48 GMT

Hello!

I'm trying to create a parameterised variable 'My_Function' and pass it a whole bunch of filters to be used in set analysis.

The problem is that the filters have a comma ',' between them for use in set analysis, and the function treats this as a separator for multiple variables.

Example parameterised variable 'My_Function':

SUM( {<$1> } Quantity)

I would call this function with:

My_Function($(vDateFilter),$(vType))

There would actually be 5+ filters and afew different combinations of them.

Where vDateFilter= Date = {"<=$(vMaxDate)"}

and vType= [LinkType] = {01}

What QlikView actually does is:

SUM( {<Date = {"<=$(vMaxDate)"}> } Quantity) and this will evaluate ok and produce a value, but the other filters such as vType do not get passed over.

I'd like QlikView todo this

SUM( {<Date = {"<=$(vMaxDate)"}, [LinkType] = {01} > } Quantity)

I have tried adding the comma into a variable called vComma and passing $(vDateFilter)$(vComma)$(vType)

Also tried various combinations of dollar expansion and quotes etc, but just not getting what I'm looking for.

Any suggestions?

Re: Parameterised variable as a string

Gysbert_Wassenaar — Mon, 06 Oct 2014 10:24:12 GMT

If you want to pass five parameters then you have to define five paramaters too:

SUM( {<$1, $2, $3, $4, $5> } Quantity)

Re: Parameterised variable as a string

peter_turner — Mon, 06 Oct 2014 10:37:47 GMT

Hi,

I thought about that, but sometimes where will be 2 parameters, sometimes 5 or more and i was looking to cover all situations with a single 'variable'.

I can add additional parameters into the function, if they are 'unused' would they effect the calculations?

SUM( {<$1, $2, $3, $4, $5, $6, $7, $8, $9> } Quantity)

but called using

My_Function($(vDateFilter),$(vType))

Re: Parameterised variable as a string

tresB — Mon, 06 Oct 2014 11:25:14 GMT

If they are unused they would not affect the calculation (that is what I tested). Hence, perhaps you can go with defining additional parameters.

Re: Parameterised variable as a string

peter_turner — Mon, 06 Oct 2014 12:03:43 GMT

It does look like the unused parameters don't effect the calculation, as they don't effect the selections in the Set Analysis.

So I've gone with the approach of adding extra parameters in case I ever need to use them.

Thanks for the responses!

Re: Parameterised variable as a string

thomastc — Mon, 09 Mar 2015 12:21:21 GMT

If you wanted to only use one parameter you'll have to do a lot of escaping of characters.

For instance the following expression:

=Sum({<Dim3={'Z'}, Dim2 = {'d', 'e'}>}Expression1)

Popped into a variable and given a parameter for the set analysis:

Sum({<$1>} Expression1)

The parameter for $1 could be in a variable 'vParamVar' say:

'Dim3={' & chr(39) & 'Z' & chr(39) & '}' & chr(44) & 'Dim2 = {' & chr(39) & 'd' & chr(39) & chr(44) & chr(39) & 'e' & chr(39) & '}'

Then to call the expression you would need todo the following:

$(='$(Variable1(' & $(=vParamVar) & '))')

Both ways have their merits!