topic Issue with the symbol ' into dropdown list and set analysis in QlikView

Issue with the symbol ' into dropdown list and set analysis

fabb95501 — Fri, 20 Mar 2020 14:05:52 GMT

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

Re: Issue with the symbol ' into dropdown list and set analysis

dplr-rn — Fri, 20 Mar 2020 18:27:25 GMT

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?

Re: Issue with the symbol ' into dropdown list and set analysis

fabb95501 — Mon, 23 Mar 2020 08:57:06 GMT

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