This forum is for user/member-created articles across the entire Qlik portfolio. Any member that is logged in can create and publish an article here. You must choose the appropriate label in order for the articles to be properly categorized.
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))) ' )
@tkas these are parameters
for examptle, see the pic below, $1 =sum, $2= is empty, $3 = 1;2 $4 = is empty
