Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Pls tell me expression ?

My Condition is   where   PIN='122001' or '122002' or '122003'  then output is   hyd   if its  not    then  output  is   banglore 

pls  TELL ME  FOR THIS  CONDTION  I  WANT  WRIGHT  A   LOGIC  I  AM  VERY  BAD   IN WRITING  LOGICS

3 Replies
MVP
MVP

Re: Pls tell me expression ?

=if(match(PIN, '122001', '122003'), 'hdy','banglore')

or in script

...

if(match(PIN, '122001', '122003'), 'hdy','banglore') as FIELD,

...

Not applicable

Re: Pls tell me expression ?

as   filed means     we  nedd  to  write  field  name  here?   if   field  is   product   then   as  product?  pls   tell me  immediaately

MVP
MVP

Re: Pls tell me expression ?

FIELD will be the new field containing the output of your conditional expression in the load. It's your turn to add more details about the context you want to create the expression. Some input data may also ve helpful.

Community Browser