Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
psankepalli
Partner - Creator III
Partner - Creator III

QV11 Functions Cheatsheet?

Hello Everyone,

Happy Friday!

Does anyone has Qlikview 11 Functions cheatsheet?

Thanks

KR

5 Replies
Anonymous
Not applicable

A few years old but could still be useful :

Qlikview - Brief Functions Chart.pdf

psankepalli
Partner - Creator III
Partner - Creator III
Author

Thank you Albert & Mark for your replies.

Not applicable

Hi prasanna ,

This is the complete tutorial for qlikview

QlikView ‒ Using QlikView Help

HirisH_V7
Master
Master

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

HirisH
“Aspire to Inspire before we Expire!”