Issue with the symbol ' into dropdown list and set analysis

[fabb95501]

Hi all,

in the Qlikview file attached, when I select a value from dropdown list (field: country) which contains the following symbol ' (in this case "Cote d'Ivoire"), it causes an error in the set analysis (see the file attached).

The value "Cote d'Ivoire" is mandatory into dropdown list box.

I attached even the Excel file, which contains values for dropdown list, if you feel necessary change the field format into Excel file.

Regards,

Fabio

[dplr-rn · Accepted solution]

replace ' in the set expressions with "

e.g. Country Check]={"$(vCountry)"}

check the new text object in the attached

But a bigger question. why are you doing it as variables? why not just give simple country, region, filterbox. Wouldnt that be simpler?

[fabb95501]

Hi, thanks for your answer.

In my complete application, I need a form that can't filter data into other object, that's why I use variables.

Regards,

Fabio