' issue in set analysis

[#1]

Hello All,

I am having a big issue with this expression because of the symbol " ' ".Please find below my expression:

= Count({<Q24a={'OUI, tous les incidents ont été résolus'}>}Q24a) / Count({<Q24a={'NON, aucun incident n'a été résolu','NON, mais ces incidents sont en cours de résolution','NON, seulement une partie des incidents a été résolue'}>}Q24a)

I believe that the issue might be with this part : 'NON, aucun incident n'a été résolu'

Any idea how i can solve this pls?

Many Thanks,

Hasvine

[Gysbert_Wassenaar]

The escaping works fine here. But you can also try another kind of quote character like for example a backtick character ` : =count({<Q24a={`NON, aucun incident n'a été résolu`}>}Q24a)

I suspect the quotes have nothing to do with the problem. Check your data thoroughly. Please post a small qlikview document that illustrates the problem if you need more help.

[#3]

I just copied your expression and paste in mine and it worked. 😄

Thanks a lot.

KR,

Hasvine