11 Replies Latest reply: Mar 25, 2016 8:18 AM by Hasvine Dhurmea

# ' issue in set analysis

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

• ###### Re: ' issue in set analysis

Can you try this:

=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 put two single quotes which forms a escape sequence: Escape sequences

• ###### Re: ' issue in set analysis

It doesnt work but is there a way for example where I can say something like that

Count({<Q24a={'OUI*'}>}Q24a)// Count({<Q24a={'NON*}>}Q24a)

I tried it but it is not working.

Many Thanks,

Hasvine

• ###### Re: ' issue in set analysis

You did not add a single quote at the end of your denominator expression:

Count({<Q24a={'OUI*'}>}Q24a)/Count({<Q24a={'NON*'}>}Q24a)

• ###### Re: ' issue in set analysis

I added it but it is still not working..shows 0 as result..

Is there a way to say lets say 'Start with' or 'Contains' which can be use in set analysis?

KR,

Hasvine

• ###### Re: ' issue in set analysis

Seems to be working in the attached sample

• ###### Re: ' issue in set analysis

I think this part has the problem:

Count({<Q24a={'OUI*'}>}Q24a)

I checked in the database and 'OUI, tous les incidents ont été résolus' is there.

I broke the expression into two:

Count({<Q24a={'NON*'}>}Q24a)

This 1 is working correctly but both are identical.

Thank you,

Hasvine

• ###### Re: ' issue in set analysis

This 1 is working correctly but both are identical.

Both are identical? Not sure I understand what you mean?

• ###### Re: ' issue in set analysis

Like the only thing which change is the expression is only the {'OUI*'} and {'NON*'}

• ###### Re: ' issue in set analysis

Have you looked at my attached sample? What is difference between what's attached and what's in your original data? Can you update the sample to make sure to capture changes in the sample so that we can see the issue?

• ###### Re: ' issue in set analysis

I just copied your expression and paste in mine and it worked. :-D

Thanks a lot.

KR,

Hasvine

• ###### Re: ' issue in set analysis

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.