# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for
Did you mean:
Not applicable

## Set Analysis - Search String

Hi all,

Is it possible to do a greater than / less than on a string in set analysis, like

SUM({\$<Field= {“<= \$(Variable)”}>} MeasureField)

where \$(Variable) contains a string value?

If not, what should be a good work around for this?

Regards,

Björn

1 Solution

Accepted Solutions
Partner - Champion III

There is two special operators called precedes and follows that could be used in your case I think:

SUM({\$<UniqueID= {“=FieldX precedes '\$(Variable)'”}>} MeasureField)

Here is the documentation of precedes and follows from the manual:

# Relational Operators

All relational operators compare the values of the operands and return true (-1) or false (0) as the result. All relational operators are binary.

 < Less than A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. <= Less than or equal A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. > Greater than A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. >= Greater than or equal A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. = Equals A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. <> Not equivalent to A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. precedes ASCII less than Unlike the operator no attempt is made to make a numeric interpretation of the argument values before the comparison. The operation returns true if the value to the left of the operator has a text representation which, in ASCII comparison, comes after the text representation of the value on the right.Example:' 23' follows ' 111' returns truecompare this to:' 23' > ' 111' returns false

14 Replies
MVP

What exactly does Variable include (What String)?

Partner - Champion III

There is two special operators called precedes and follows that could be used in your case I think:

SUM({\$<UniqueID= {“=FieldX precedes '\$(Variable)'”}>} MeasureField)

Here is the documentation of precedes and follows from the manual:

# Relational Operators

All relational operators compare the values of the operands and return true (-1) or false (0) as the result. All relational operators are binary.

 < Less than A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. <= Less than or equal A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. > Greater than A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. >= Greater than or equal A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. = Equals A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. <> Not equivalent to A numeric comparison is made if both operands can be interpreted numerically. The operation returns the logical value of the evaluation of the comparison. precedes ASCII less than Unlike the operator no attempt is made to make a numeric interpretation of the argument values before the comparison. The operation returns true if the value to the left of the operator has a text representation which, in ASCII comparison, comes after the text representation of the value on the right.Example:' 23' follows ' 111' returns truecompare this to:' 23' > ' 111' returns false

Specialist

Hi,

Can you specify exact requirement of your's.or better for string matching you can use WildMatch().

MVP

May be this helps:

Exp:

Concat({<String={ "=String>'BBB' "}>} String, '-')

Master III

May be try this

SUM(if( Field<=Variable, MeasureField))

or

SUM(if( Field<=\$(Variable), MeasureField))

Master III

Partner - Champion III

Not applicable
Author

Variable contains one of fields of Field.

For example;

Field contains: SP_AAA, SP_BBB, SP_CCC

Variable contains: SP_BBB

MVP

IF you have greater than and lesser than parameters than you can try like this :

SUM({\$<Field= {“>=\$(Variable2)<= \$(Variable)”}>} MeasureField)

Community Browser