topic Re: Compare the field value in QlikView

Compare the field value

ajaykumar1 — Sun, 16 Feb 2014 12:45:28 GMT

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:

AREA	LRM	AMR
California	California	Siliconvalley
US	UK	US
INDIA	UK	US

output:

California

Thanks,

Ajay

Re: Compare the field value

swuehl — Sun, 16 Feb 2014 12:49:06 GMT

I think I would do it in the script like

OutputTable:

LOAD

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

Resident InputTable;

Re: Compare the field value

Sun, 16 Feb 2014 12:56:07 GMT

Hi,

take a look at example app.

HTH

Roland

Re: Compare the field value

Sun, 16 Feb 2014 13:03:05 GMT

use like this

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

Re: Compare the field value

ajaykumar1 — Sun, 16 Feb 2014 13:04:29 GMT

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

Re: Compare the field value

Sun, 16 Feb 2014 13:11:52 GMT

in script

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

Re: Compare the field value

Sun, 16 Feb 2014 15:33:33 GMT

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.