LogoLogo
Version 1.66
Version 1.66
  • nedyx
  • Welcome to nedyx
  • 🚀Getting started
    • Preparation
    • Basic widget formatting
    • The first formula
    • More formulas
    • Combine several tables
    • Add a new page
    • Widget references across pages
    • Add a chart widget
    • Further adjustments
  • 🖊️Working with nedyx
    • Apps
    • Live and Edit mode
    • The Header bar
    • The Navigation tab
    • Pages
    • Widgets
      • Widget types
      • Adding widgets
      • Widget selection
      • Widget positioning
      • Style tab
      • Settings tab
      • Cell styles
      • Chart content
      • Chart properties
      • Undo / redo
    • Databases
      • Connect to a database
      • Get external data
    • File management
  • 📖ClearLines Functions
    • General Aspects
      • Formula structure
      • The formula editor
      • Actions
      • Calculated widget properties
        • Content
        • Chart labels
        • Column widths and Row heights
        • Connection
        • Editable
        • MinY and MaxY
        • Style
        • Tooltips
        • Visible
      • Calculated page properties
        • Visible (for pages)
      • Ranges
      • Widget references
      • Menu selection references
      • Cell references
      • Menu widget synchronization
    • Action functions
      • ACTIONCOLUMN
      • ACTIONCONTENT
      • ACTIONROW
      • CLICK
    • Database functions
      • CALLURL
      • EXECUTE
      • GETDATA
      • INSERTDATA
      • GETDBCOLUMNNAMES
      • GETSTATEMENT
    • Date functions
      • CREATEDATE
      • DATE
      • DATETOTEXT
      • DAY
      • GETTIMEZONEOFFSET
      • HOUR
      • MILLISECOND
      • MINUTE
      • MONTH
      • NOW
      • SECOND
      • TODAY
      • WEEKDAY
      • YEAR
    • Import / export functions
      • DOWNLOAD
      • DELETEFILE
      • DOWNLOADEXCEL
      • DOWNLOADFILE
      • DOWNLOADPDF
      • EXCELCREATE
      • GETFILELIST
      • PDFCREATE
      • POSTMESSAGE
      • SCANCODE
      • SENDEMAIL
      • UPLOAD
      • UPLOADFILE
    • Logical functions
      • AND
      • IF
      • ISEMPTY
      • ISUSERACTION
      • LOOP
      • NOT
      • OR
    • Mathematical functions
      • ABS
      • BINTODEC
      • BINTOHEX
      • COS
      • COT
      • DECTOBIN
      • DECTOHEX
      • EXP
      • HEXTOBIN
      • HEXTODEC
      • LN
      • LOG
      • MAX
      • MIN
      • MOD
      • MROUND
      • NUMBER
      • PI
      • RAND
      • ROUND
      • SIN
      • SQRT
      • SUM
      • TAN
    • Navigation functions
      • CLOSE
      • GETPAGES
      • GETURLPARAM
      • MESSAGE
      • OPEN
      • OPENWEBPAGE
      • PAGE
      • QUESTION
    • Range functions
      • AGGREGATE
      • CELL
      • CELLREF
      • CLEAR
      • COLUMN
      • COLUMNS
      • COMBINE
      • CONVERT
      • COUNT
      • CSVTORANGE
      • CUMULATE
      • DIFF
      • EMPTY
      • FILTER
      • GETTYPE
      • INSERTRANGE
      • INTERSECTION
      • LOOKUP
      • PIVOT
      • RANGE
      • RANGETOCSV
      • RANGETOHIERARCHY
      • RANGETOROW
      • RANGETOJSON
      • JSONTORANGE
      • ROW
      • ROWS
      • ROWTORANGE
      • SEQUENCE
      • SORT
      • TRANSPOSE
      • UNIQUE
      • UNPIVOT
      • VISIBLEHIERARCHY
    • Text functions
      • CHAR
      • CODE
      • CREATEMEMBER
      • FIND
      • HASH
      • HIDDENTEXT
      • HTMLTOJSONTEXT
      • LEFT
      • LEN
      • LOWER
      • MID
      • RIGHT
      • SUBSTITUTE
      • TEXT
      • TRIM
      • UPPER
    • User management functions
      • APPLIST
      • ADDUSER
      • APPSHARELIST
      • REMOVEUSER
      • SHAREAPP
      • UPDATEUSER
      • USERLIST
      • USERNAME
    • Widget functions
      • GETSELECTION
      • LOADWIDGETCONTENT
      • NAME
      • SETSELECTION
      • STOREWIDGETCONTENT
      • UPDATE
  • 🔐Security
    • User Management
      • Workspaces
      • Workspace Roles
      • Adding Users to a Workspace
      • App Roles
      • Share an App with Other Users
      • Guest Access
      • Change Password
  • Appendix
    • Keyboard shortcuts
    • Error handling
    • Feature preview
    • Supported browsers
    • System requirements for on-premises installations
Powered by GitBook
On this page
  1. ClearLines Functions
  2. Range functions

PIVOT

Converts a row-based range of values to a column-based range of values.

Syntax

PIVOT(range; numRowElements)

  1. range - the range whose content should be converted in a pivot structure - Value type: a range of any data

  2. numRowElements - specifies how many starting columns from range should be used for the rows of the result range - Value type: integer (optional, default value: 1)

Remark

  • The function converts the single values from range into values in multiple columns in the result range. Each value is specified by its (single or multiple) row and column attributes.

Examples

Example 1 - PIVOT with one column for rows and one column for columns.

Example 2 - PIVOT function with two columns with row attributes.

Example 3 - PIVOT function with two columns with column attributes.

📖