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:

1. Use REPLACE() function
2. Use CHR(44) instead of comma

I will show how I do it.

1. 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

1. 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)))  '  )