topic Re: functions used in qlikview scripting in QlikView

functions used in qlikview scripting

Sat, 08 Feb 2014 12:39:49 GMT

hi,

can any body post your regular used functions in qlikview scripting not in UI side.

Regards

Mahesh T

Re: functions used in qlikview scripting

MK_QSL — Sat, 08 Feb 2014 13:53:12 GMT

Hi Mahesh,

There are many functions and difficult to give you list of all but you can get all of them by reading QlikView Reference Manual.

Some of them are

Left, Right, Mid,Subfield,

Date,Month, Year, MonthStart, MakeDate, YearStart, Today(), Week, Now,

Min, Max, Avg,

ISNULL,

Peek, ApplyMap, Rand, RangeSum, RangeMin, RangeMax, Previous,

SUM, Avg,

Exists, RecNo, IterNo, Ceil, Floor,

Capitalize,

IF,...match, firstsortedvalue

There are many more... but I dont remember them all..

Re: functions used in qlikview scripting

Anonymous — Sat, 08 Feb 2014 14:28:21 GMT

Hi Mahesh,

as Manish said, have a look at the reference manual. there is a section called Other Functions.

You will find most of the script functions.

Cheers,

Re: functions used in qlikview scripting

Sat, 08 Feb 2014 17:30:15 GMT

Superb.it helps alot for beginners.

regards

Mahesh T

Re: Re: functions used in qlikview scripting

IAMDV — Sat, 08 Feb 2014 20:15:52 GMT

Hi Mahesh,

There are loads of functions in QV. Here is list of my favourite/ most used ones.

Script:

ApplyMap()
Date()
Date#()
Num()
Num#()
Trim()
SubField()
AutoNumber()
RecNo()
RowNo()
FirstSortedValue()
Text()
Concat()

UI:

IsNull()
Num()
Concat()
FirstSortedValue()
Pick()
Match()
SubField()
SubStringCount()
GetFieldSelections()
GetSelectedCount()

There are many more and I can't recall them but you can also watch videos on blog...if you wanted to learn QV.

www.QlikShare.com

Cheers,

Re: functions used in qlikview scripting

Mon, 10 Feb 2014 05:01:55 GMT

Hi Mahsh,

PFA.

Regards,

Raja.

Re: functions used in qlikview scripting

Tue, 15 Apr 2014 11:01:15 GMT

i want to examples of above functions deepak ,can you provide examples

Re: functions used in qlikview scripting

IAMDV — Tue, 15 Apr 2014 11:13:02 GMT

www.QlikShare.com

Check my blog.