article Variables with Parameters when the value has a comma "," in Member Articles

Variables with Parameters when the value has a comma ","

ValeriyaBartosh — Wed, 21 Sep 2022 17:07:35 GMT

All we have situations, when parameter has a comma “,”, for example, when we want to use set analysis as parameter. Qlik stops to understand where the first parameters ends and the second starts.

There are two methods how to resolve this problem:

Use REPLACE() function
Use CHR(44) instead of comma

I will show how I do it.

REPLACE

Create variable, determine all necessary parameters, use replace() function for parameter witch potentially could have comma as a parameter value.

Use variable as expression, send parameter using delimiter

CHR()

Create variable, determine parameters

Create parameters as variables, change commas with chr(44)

Use variable as expression

1 – Original variable call does not work

$( TON( ,,$(LY)) )

2 – Add quotes to use string concatenation. Qlik convert chr(44) to real comma, but now it is a text.

=' $(TON( ,,$(LY))) '

3 – Say “Calculate!”

$(=' $(TON( ,,$(LY))) ' )

Re: Variables with Parameters when the value has a comma ","

DzmitryYasinski — Mon, 26 Aug 2019 12:00:53 GMT

Great work! Very useful information!

Re: Variables with Parameters when the value has a comma ","

tkas — Fri, 30 Dec 2022 06:00:16 GMT

I FAILED TO UNDERSTAND THIS EXPRESSION. WHAT IS $1,$2,$3 IN THIS EXPRESSION???

@ValeriyaBartosh

Re: Variables with Parameters when the value has a comma ","

ValeriyaBartosh — Fri, 30 Dec 2022 08:14:21 GMT

@tkas these are parameters

for examptle, see the pic below, $1 =sum, $2= is empty, $3 = 1;2 $4 = is empty