Discussion Board for collaboration on QlikView Scripting.
This formula doesn't work. I have created it within a Master MeasureWhat this formula does:
- Otherwise assign Fail
ISSUE: it assigns Pass only if the answer is 1 equal to 28.
aggr(count(your_answer), [Email Address])=1
Guess that it's a syntax problem
Thank you in advance
PS. Please note that I am not in the script but in the Master Items Creation
I'm not sure if I have understand your conditions right but the expression should look more like this:
if(sum(aggr(count(your_answer), [Email Address])) =1
Thanks for your reply and apologies if I wasn't clear.
this is the issue I have:
my formula works, but I have a problem with identifying strings.If I take my formula and instead of #java and #javascipt I put 29 and 30it works perfectly
So I guess that it's a syntax problem related to "Scanning a field and identifying if there is a specific string within it"
Try WildMatch() function