Some functions not able to understand

[#1]

Hi All,

I am workng with one of the qlikview application and in that application some of the commands i am not able to understand like

makedate,  mapload, wildmatch, resident, directory....... Could someone please explain..... thanks in advance. I am new to qlikview and trying to understand scripts which are already there in my system...... regarding my project.

[rohit214]

hi Suresh

just go through the help

thanks

rohit

[SunilChauhan]

makedate is to create date

ex:makedate(2011,01,03)->01/03/2011

Mapload is used to add a field from mapping table to other table.

tab1:

Mapping Load

from path;

tab2:

Load

applymap(...) as fieldname

from path2

Mapping table will be invisible after loading

wildmatch is used to find matching characters both case insensitive and with wildcard characters

ex:wildmatch(fieldname,'S*') will find all the name start with s

resident is table which based on other table

resident =base table fields + some extra calculated fields

dirctory will show you the dirctory of any file

hope this helps