topic Re: ' issue in set analysis in QlikView

' issue in set analysis

Fri, 25 Mar 2016 11:22:27 GMT

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

sunny_talwar — Fri, 25 Mar 2016 11:27:01 GMT

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

Fri, 25 Mar 2016 11:30:51 GMT

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

sunny_talwar — Fri, 25 Mar 2016 11:32:42 GMT

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

Fri, 25 Mar 2016 11:40:00 GMT

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?

Many Thanks for your help.

KR,

Hasvine

Re: ' issue in set analysis

sunny_talwar — Fri, 25 Mar 2016 11:54:28 GMT

Seems to be working in the attached sample

Re: ' issue in set analysis

Fri, 25 Mar 2016 12:00:25 GMT

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

sunny_talwar — Fri, 25 Mar 2016 12:03:25 GMT

This 1 is working correctly but both are identical.

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

Re: ' issue in set analysis

Fri, 25 Mar 2016 12:05:44 GMT

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

Re: ' issue in set analysis

sunny_talwar — Fri, 25 Mar 2016 12:09:02 GMT

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

Gysbert_Wassenaar — Fri, 25 Mar 2016 12:10:31 GMT

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.

Re: ' issue in set analysis

Fri, 25 Mar 2016 12:18:12 GMT

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

Thanks a lot.

KR,

Hasvine