topic calculet 2 feild in QlikView

calculet 2 feild

Anonymous — Mon, 21 Jan 2013 07:04:19 GMT

hi,

i wrote in the script the next line:

=if(Match([destinetion],'3' and [target],'A'),'123')

but i get nothing in the result.

when i separate it it's o,k.

please help me.

thanks'

sivarajs — Mon, 21 Jan 2013 07:42:17 GMT

Try this

=if(Match(destination,'3' )and Match( [target],'A'),'123')

Mon, 21 Jan 2013 07:52:55 GMT

plee see the attachement.

since within match() function we does not take and operator.

and match() function work on selection.

hope this helps you.

=if(Match(destination,'3') and MATCH(target,'A'),'123')