This site requires JavaScript to be enabled
IE BUMPER

Logo

Dear Tricentis qTest users,

If you would like to submit a Tricentis qTest ticket,

please use this support request form.

Tosca Version
IncidentLookup using list
Language
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
  Help
IE BUMPER
Categories
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
AND
Finds a match if both terms exist in a document (an intersection of sets).
NOT, minus (-), or exclamation point (!)
Excludes documents that contain the term after NOT (a difference of sets).
Wildcards
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Phrases
Quotation marks (")
Use quotation marks to search for an exact phrase with multiple terms.
For examples and more information look at our Knowledge Base: Advanced Search On The Support Portal

how to calc function with if condition

i am using if condition for get one value which depends on the combination of diffrent values so try the if function as we use in excel with in Calc but is saying that not a valid formula.

I tried diffrent below combination.

1.{calc[if({b[a]}='0','Y','N')]} 

2.{calc[if(""{b[a]}='0','Y','N'"")]} 

could anyone ever try this ?

please let me know .

Thanks, Abhilash

0 0

Andreas Windbichler

Created: 2019-03-22 08:03:50

Hello Abhilash,

Please keep in mind that TBox has specific escaping rules. Dynamic expressions like buffers must be escaped with 4 quotes, strings with 3 quotes. See below example, which worked for me:

Hope this helps.

BR Andreas

0 0

Abhilash Tomar

Created: 2019-03-22 09:20:34

Hi Andreas,

 

thnaks for help,

it is working perfectly

 

Regrads,

Abhilash

 

0 0

Abhilash Tomar

Created: 2019-03-22 09:20:38

Hi Andreas,

 

thnaks for help,

it is working perfectly

 

Regrads,

Abhilash

 

IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial