Qlik Community

QlikView Documents

Documents for QlikView related information.

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

Partner
Partner

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

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.

clipboard_image_0.png

Use variable as expression, send parameter using delimiter

clipboard_image_1.png

 

  1. CHR()

Create variable, determine parameters

clipboard_image_2.png

 

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

clipboard_image_3.png

 

clipboard_image_4.png

Use variable as expression

clipboard_image_5.png

1 – Original variable call does not work

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

clipboard_image_6.png

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

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

clipboard_image_7.png

3 – Say “Calculate!”

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

clipboard_image_8.png

 

 

 

Comments
DzmitryYasinski
New Contributor

Great work! Very useful information!

0 Likes
Version history
Revision #:
2 of 2
Last update:
a month ago
Updated by:
 
Contributors