functions used in qlikview scripting

[#1]

hi,

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

Regards

Mahesh T

[MK_QSL]

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..

[Anonymous]

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,

E

[#4]

Superb.it helps alot for beginners.

regards

Mahesh T

[IAMDV · Accepted solution]

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,

DV

[#6]

Hi Mahsh,

PFA.

Regards,

Raja.

[#7]

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

[IAMDV]

www.QlikShare.com

Check my blog.