topic Check if a Value in a field exists in QlikView

Check if a Value in a field exists

Wed, 25 Aug 2010 15:56:08 GMT

Hi All,

I am writing a macro and I am trying to check to make sure the value exists in the field and if it does not I would like to write an error to my log file. I have tried declaring a variable and hoping that it would return True if it was able to be selected and False if not, but if my value exists it is selected and my variable returns False. My code is:

checkValue = Document.Fields(Attr1).Select(Attr2)

if checkValue is true then

....

Else

lg.WriteLine("Command could not be done because the value does not exist in the field.

Thanks

Check if a Value in a field exists

Anonymous — Wed, 25 Aug 2010 19:36:09 GMT

checkValue =ActiveDocument.Evaluate("count({$<Field={'Value'}>} Field)")

If checkValue>0, value exists

Check if a Value in a field exists

Tue, 01 Feb 2011 13:55:58 GMT

Hi,

Tried to use your statement but it doesnt work for me.

if my field name is f and the value is v, what should this statement look like?

checkValue =ActiveDocument.Evaluate("count({$<Field={'Value'}>} Field)")

Thanks.

Check if a Value in a field exists

Anonymous — Tue, 01 Feb 2011 16:28:53 GMT

It will be
checkValue =ActiveDocument.Evaluate("count({$<f={'v'}>} f)")

Re: Check if a Value in a field exists

TKendrick20 — Tue, 19 Jan 2016 15:23:38 GMT

This works great! Here's a snippit of what I'm doing in C#.

I added DISTINCT so that the output of 1 means the value exists in that field while an output of 0 means it does not exist
I added brackets "[]" around the field name so it will work with field names containing spaces and return 0 if the field name is empty

string countString = @"COUNT(DISTINCT{$<[" + fieldName + @"]={'" + value + @"'}>}[" + fieldName + @"])";

if (Int32.Parse(ReportControl.QVDoc.Evaluate(countString)) == 1)

{

//whatever

}