Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
I just copied your expression and paste in mine and it worked. 😄
Thanks a lot.
KR,
Hasvine