topic Re: Numeric Search(> or <) with Match in QlikView

Numeric Search(> or <) with Match

priyarane — Wed, 25 Nov 2020 16:16:04 GMT

hi Community,

Is there any way to use Numeric Search(> or <) with Match , I am trying to search like

if(value>0,'T',value<0,'p') as test

so is there any way to use match in above if condition.

-Priya

Anil_Babu_Samineni — Thu, 07 Dec 2017 06:08:23 GMT

But What are the T and P in your statement?

jonathandienst — Thu, 07 Dec 2017 06:10:39 GMT

If the conditions are mutually exclusive:

=If(value > 0, 'T', 'p')

Or, if not:

=If(value > 0, 'T', If(value < 0, 'p'))

Or use Match like this:

=Pick(Match(-1, value > 0, value < 0), 'T', 'p')