Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

code for multiple flags using appply map

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

Tags (1)
2 Replies

Re: code for multiple flags using appply map

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
Valued Contributor III

Re: code for multiple flags using appply map

Hi, Pavan.

This is bread and butter for applymaps.

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

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Alternatively, go to http://www.askqv.com/

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

Cheers,

Neil

Community Browser