topic Re: Scanning a field and identifying if it contains a string in QlikView

Scanning a field and identifying if it contains a string

Sat, 05 Dec 2015 12:22:27 GMT

Hi Guys,

This formula doesn't work. I have created it within a Master Measure
What this formula does:

- Find the email addresses that have submitted one and only one answer (aggregate your_answer by email address)
- if this unique answer is = 28 or #javascript or #javas --> Assign Pass

- Otherwise assign Fail

ISSUE: it assigns Pass only if the answer is 1 equal to 28.

if the your_answer grouped by email address is 1 and equal to #javascript or #javas it assignes FAIL

if(

(

aggr(count(your_answer), [Email Address])=1

)

AND if(

[your_answer]=28 OR [your_answer]='#javascript' OR [your_answer]='#java',[your_answer]

)

),'Pass', 'Fail'

)

Guess that it's a syntax problem

If I take my formula and instead of #java and #javascipt I put 29 and 30
it works perfectly

but I need to formula to scan the fields and identify if they contain strings (#java and #javascript)

So I guess that it's a syntax problem related to "Scanning a field and identifying if there is a specific string within it"

the syntax '#javascript' doesn t work. The syntax '$(#javascript)' doesn t work either.
again, if I want to "Scan a field and identify if there is a specific number within it", it works.

Suggestions?

Any Idea?

Thank you in advance

PS. Please note that I am not in the script but in the Master Items Creation

Re: Scanning a field and identifying if it contains a string

Clever_Anjos — Sat, 05 Dec 2015 13:38:49 GMT

Paolo, please do not cross post same question: AND / IF / OR in master measures ISSUE

Re: Scanning a field and identifying if it contains a string

Sun, 06 Dec 2015 17:22:05 GMT

Hi,

Apologies for the double post, how can I post a question in more than 1

group?

Now I have just access to a very few groups and the answers I get are

always too complex for me

I am a beginner, I can't afford a course for the moment, I have programming

skills but I find things in Qlik quite difficult sometimes

Furthermore, why I cannot reply to the post anymore?

No reply button, no action available

Best

Re: Scanning a field and identifying if it contains a string

MarcoWedel — Sun, 06 Dec 2015 20:44:41 GMT

‌check if you are logged in.

regards

Marco

Re: Scanning a field and identifying if it contains a string

jonathandienst — Mon, 07 Dec 2015 05:40:38 GMT

>>If I take my formula and instead of #java and #javascipt I put 29 and 30

it works perfectly

If it does, are you sure you are getting the answer you expect. The syntax looks dodgy to me.

>>Scanning a field and identifying if there is a specific string within it

Check the manual or on line help for

Match(FIELD, 'string1', 'string2', ...)
WildMatch(FIELD, '*string1*', '*string2*'. ...)
FIELD Like '*string1*'
Index(FIELD, 'string')

One of those should be suitable for your needs

Re: Scanning a field and identifying if it contains a string

Tue, 08 Dec 2015 12:48:52 GMT

Hi Jonathan,

Thanks for your tips. Basically what I would like to do is giving the title of "Top Developer" to the emaill addresses that answered only once to the question and answered either 28, or #javascript or #java

This should be a master measure

Is it possible to do it?

I have created a master measure named "Top Developer" and I inserted this formula

count(

if(

(match(your_answer, 28, '#javascript','#java')) AND (your_answer), [Email Address]=1

)

but it doesn't give me the result I expect in terms of number

Would you be able to give me a hint?
I am now reading the Qlik University stuff to learn more

Many Thanks