Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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