topic Some functions not able to understand in QlikView

Some functions not able to understand

Tue, 03 Jan 2012 00:09:46 GMT

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.

Some functions not able to understand

rohit214 — Tue, 03 Jan 2012 05:07:47 GMT

hi Suresh

just go through the help

thanks

rohit

Some functions not able to understand

SunilChauhan — Tue, 03 Jan 2012 06:14:55 GMT

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