Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

psankepalli
Contributor III

QV11 Functions Cheatsheet?

Hello Everyone,

Happy Friday!

Does anyone has Qlikview 11 Functions cheatsheet?

Thanks

KR

Tags (1)
5 Replies

Re: QV11 Functions Cheatsheet?

Re: QV11 Functions Cheatsheet?

A few years old but could still be useful :

Qlikview - Brief Functions Chart.pdf

psankepalli
Contributor III

Re: QV11 Functions Cheatsheet?

Thank you Albert & Mark for your replies.

Not applicable

Re: QV11 Functions Cheatsheet?

Hi prasanna ,

This is the complete tutorial for qlikview

QlikView ‒ Using QlikView Help

hirishv7
Honored Contributor

Re: QV11 Functions Cheatsheet?

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

Community Browser