Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajaykumar1
Creator III
Creator III

Compare the field value

Hi All,

i have a req like below.

If AREA value equal to LRM then i have to show LRM else go to AMR if in case both not satisfied then take AMR as per belwo input and output.How we can get in script level as well in dimension level or in expression level(set analysis is+ve)

Input:

AREALRMAMR
CaliforniaCaliforniaSiliconvalley
USUKUS
INDIAUKUS

output:

California
US
US

Thanks,

Ajay

6 Replies
swuehl
MVP
MVP

I think I would do it in the script like

OutputTable:

LOAD

     if(AREA = LRM, LRM, AMR) as OUTPUT

Resident InputTable;

Not applicable

Hi,

take a look at example app.

HTH

Roland

Not applicable

use like this

if(AREA=LRM, 'LRM','AMR')

ajaykumar1
Creator III
Creator III
Author

Thanks both....its working. If in case that AREA field is coming from some other table and remaing 2 fields are coming from same table.

Then design level already sended script will work but how to do that in script level.

thanks,

ajay

Not applicable

in script

if(AREA=LRM, 'LRM','AMR') as Flag

Not applicable

Hi ajay,

if you have the fields in two different tables, plse send some adequate sample data as input. With this we should be able to build the script.

RR