senser_timeline_fmt: Retrieves a dataframe containing timeline data with a...
In ralfbecher/senser: R Package to retrieve data from Qlik Sense

Description Usage Arguments Details Value Examples

View source: R/senser_timeline_fmt.R

This function makes a REST POST call to q-risotto (the Qlik Sense REST API wrapper service) to retrieve data out of a Qlik Sense application. You will find more details about q-risotto here: https://github.com/ralfbecher/q-risotto

1 2	senser_timeline_fmt(host, port, app, hyperCubeDef, fields, tz = "UTC", format = "%d.%m.%Y")

`host`	a URL where the q-risotto service runs, usually the Qlik Sense Desktop (localhost) or Server IP addresss
`port`	a port number where to connect q-risotto,
`app`	a Qlik Sense application name to connect, usually a GUID for applications on a Qlik Sense Server
`hyperCubeDef`	a list of dimensions (field names) and measure expressions (starting with '='), see q-risotto README for more details; the 1st field needs to contain the date/timestamp values
`fields`	a list of field names which will be assigned to the resulting vectors
`tz`	a timezone to convert the date/timestamp to (default "UTC")
`format`	a date/timestamp format to convert to (default )

In the parameters, you define the Qlik Sense HyperCube by giving a set of dimensions and measure expressions (Qlik syntax). The HyperCube will then be created in the specified Qlik Sense application and the resulting data are retrieved completely by paging calls.

a dataframe with timelines containing the resulting HyperCube data

## Not run: 
host <- "http://localhost"
port <- 3000
app <- "Helpdesk Management.qvf"
hyperCubeDef <- c("Date.autoCalendar.Date", "=Count( {$<[Case Is Closed] ={'True'} >} Distinct %CaseId )", "=Count( {$<[Status]={'New'} >} Distinct %CaseId )")
fields <- c("Date", "Closed Cases", "New Cases")
senser_data(host=host,port=port,app=app,hyperCubeDef=hyperCubeDef,fields=fields)
## End(Not run)