topic Re: QV11 Functions Cheatsheet? in QlikView

QV11 Functions Cheatsheet?

psankepalli — Fri, 29 Jan 2016 17:11:45 GMT

Hello Everyone,

Happy Friday!

Does anyone has Qlikview 11 Functions cheatsheet?

Thanks

Re: QV11 Functions Cheatsheet?

Colin-Albert — Fri, 29 Jan 2016 17:14:23 GMT

Function list | Qlik Community

Re: QV11 Functions Cheatsheet?

Anonymous — Fri, 29 Jan 2016 17:29:05 GMT

A few years old but could still be useful :

Qlikview - Brief Functions Chart.pdf

Re: QV11 Functions Cheatsheet?

psankepalli — Sat, 30 Jan 2016 00:53:57 GMT

Thank you Albert & Mark for your replies.

Re: QV11 Functions Cheatsheet?

Sat, 30 Jan 2016 06:56:15 GMT

Hi prasanna ,

This is the complete tutorial for qlikview

QlikView ‒ Using QlikView Help

Re: QV11 Functions Cheatsheet?

HirisH_V7 — Sat, 30 Jan 2016 07:32:40 GMT

Hi,

check this,

BackendScript:

ApplyMap()
Date()
Date#()
Num()
Num#()
Trim()
SubField()
AutoNumber()
RecNo()
RowNo()
FirstSortedValue()
Text()
Concat()
Where()
Resident Load
order by  asc and dsc
Mid()
Text Between()
Text()
Trim()
left()
Right()
concat()
purgchar()
char()
len()
Captilaize and trim
recno()
intrno()



 UI-Fornt End:

IsNull()
Num()
Concat()
FirstSortedValue()
Pick()
Match()
SubField()
SubStringCount()
GetFieldSelections()
GetSelectedCount()
aggr
set analysis  Sum({<Yourfield=>},Sales)
rowno()

These are some mostly used functions.

HTH,

Hirish