topic Re: code for multiple flags using appply map in QlikView

code for multiple flags using appply map

Mon, 15 Sep 2014 11:00:17 GMT

Hi Friends,

I am trying to flag a column using two or three other columns like this

35_41,yyy

35-41-03, xxx

35-41-08, xxx

35-42-03-09,zzz

35-42-08,xxx

Can we use apply map here???

Thanks

avinashelite — Mon, 15 Sep 2014 11:12:13 GMT

Hi Pavan ,

Try like this:

tablename:

Mapping load Keyfeild,

Mappingfeild;

Select * from table;

Load applymap('tablename',match(keyfeild of this table) as feild

select * from Table;

ngulliver — Mon, 15 Sep 2014 11:40:43 GMT

Hi, Pavan.

This is bread and butter for applymaps.

If you need help understanding how they work have a look at this blog

This website goes through well respected QlikView blogs looking for answers and demos to your questions.

Cheers,

Neil