Issue with Dynamic Postal Code Selection in Qlik Sense

ImasLauoraza — Tue, 06 Aug 2024 14:34:38 GMT

Hi all,

I’m encountering an issue with dynamically selecting postal codes in Qlik Sense based on a distance slider. Here’s a summary of my setup and the problem I’m facing:

Setup:

Dynamic Distance: I have a slider that represents a distance value.
Postal Code Filtering: I use this distance to filter postal codes dynamically. The expression for my postal codes is:

Chr(39) & Concat(DISTINCT If($(vDistance) <= $(vInc), INSEE_COM), Chr(39) & ',' & Chr(39)) & Chr(39)

This should concatenate postal codes (e.g., 69077,69242,71481) into a format like '69077','69242','71481', where INSEE_COM is the postal code field.

Button Configuration: I’ve set up a button to use the action "Select values matching search criteria", with the criteria set to =($(vPostalCodesSearch))

Problems Encountered:

When the variable contains only one postal code, it works correctly.
With multiple postal codes, I get the error: Error in expression ')' expected = ('69077','69242','71481').

It appears that the issue may be related to how the values are formatted or separated in the expression. Could someone suggest a solution or provide guidance on how to correctly format and apply multiple postal codes as filters dynamically based on the distance from the slider? Any help or alternative approaches would be greatly appreciated!

Thank you!

topic Issue with Dynamic Postal Code Selection in Qlik Sense in App Development

Issue with Dynamic Postal Code Selection in Qlik Sense