topic when will we use peek function,match,applymap.? in QlikView

when will we use peek function,match,applymap.?

Tue, 24 Jun 2014 12:15:52 GMT

will help me..

Re: when will we use peek function,match,applymap.?

ashfaq_haseeb — Tue, 24 Jun 2014 12:19:10 GMT

Hi,

Look at the below posts

http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/25/which-conditional-functions-do-you-use

http://community.qlik.com/docs/DOC-4073

http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap

Regards

ASHFAQ

Re: when will we use peek function,match,applymap.?

juleshartley — Tue, 24 Jun 2014 12:23:10 GMT

Peek allows you to look into or 'peek' into the fields in another table

eg. Peek('Sales', 0) gives you the first record in the 'Sales' field

Match gives you the position in an expression of the value passed to it

eg.Match (M, 'Jan', 'Feb')

where M=Feb returns 2

applymap is the equivalent of 'vlookup' in excel (although has some excellent advantages). So, by using a mapping load, you can switch out on field (say an ID field) for another (say a description)

ps. QlikView Help is quite good on this stuff!