Erik Wetterberg erikwett
erikwett
/ mashup_editor_create_cube.js
Created
October 27, 2016 06:54
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //created from the mashup editor | |
| app.createCube({ | |
| "qInitialDataFetch": [ | |
| { | |
| "qHeight": 20, | |
| "qWidth": 2 | |
| } | |
| ], | |
| "qDimensions": [ | |
| { |
erikwett
/ visualization_create.js
Last active
March 25, 2017 21:32
Create a chart with Qlik Sense Visualization API
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| app.visualization.create('barchart', // a bar chart | |
| ["Case Owner Group", // one dimension | |
| "=Avg([Case Duration Time])"], // one measure | |
| {"title":"On the fly barchart"}). // set the title | |
| then(function(vis){ // when its ready | |
| vis.show("QV03"); // show the chart | |
| }); |
erikwett
/ generic_object_listbox.js
Created
June 5, 2017 15:39
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| initialProperties : { | |
| qListObjectDef : { | |
| qShowAlternatives : true, | |
| qFrequencyMode : "V", | |
| qSortCriterias : { | |
| qSortByState : 1 | |
| }, | |
| qInitialDataFetch : [{ | |
| qWidth : 2, | |
| qHeight : 50 |
erikwett
/ listbox_property_panel.js
Last active
June 6, 2017 07:43
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| dimension : { | |
| type : "items", | |
| label : "Dimensions", | |
| ref : "qListObjectDef", | |
| min : 1, | |
| max : 1, | |
| items : { | |
| label : { | |
| type : "string", | |
| ref : "qListObjectDef.qDef.qFieldLabels.0", |
erikwett
/ mashup_editor_listbox.js
Last active
June 6, 2017 08:51
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| app.createList({ | |
| "qFrequencyMode": "V", | |
| "qDef": { | |
| "qFieldDefs": [ | |
| "Department" | |
| ] | |
| }, | |
| "qExpressions": [ | |
| { | |
| "qLabel": "Closed Cases", |
erikwett
/ default_measure_data.js
Created
June 25, 2017 14:12
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //part of the result from app.getList("MeasureList",callback) | |
| { | |
| qInfo: { qId: "SLJUwQj", qType: "measure"}, | |
| qMeta: {description:"", tags:["sales"], title:"Sales Quantity"}, | |
| qData: {tags:["sales"], title:"Sales Quantity"} | |
| } |
erikwett
/ custom_measure_data.js
Created
June 25, 2017 14:21
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //part of the result from app.createGenericObject with custom qMeasureListDef | |
| { | |
| qInfo: {qId: "SLJUwQj", qType: "measure"}, | |
| qMeta: {description:"", tags:["sales"], title:"Sales Quantity"}, | |
| qData: {qMeasure: | |
| { | |
| qActiveExpression:0, | |
| qDef:"Sum([Sales Quantity])", | |
| qExpressions:[], | |
| qGrouping:"N" |
erikwett
/ custom_measure_list_definition.js
Last active
June 25, 2017 14:29
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //a measure list definition that gives you more data on the measures | |
| app.createGenericObject({ | |
| qInfo: { | |
| qType: "MeasureList" | |
| }, | |
| qMeasureListDef: { | |
| qType: "measure", | |
| qData: { | |
| qMeasure: "/qMeasure" | |
| } |
erikwett
/ QIX_handle_example.js
Created
July 4, 2017 13:07
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| //send a CreateSessionObject to the app (handle 1), request id 7 | |
| {"method":"CreateSessionObject", | |
| "handle":1, | |
| "params":[ | |
| {"qInfo":{"qId":"SheetList","qType":"SheetList"}, | |
| "qAppObjectListDef":{"qType":"sheet", | |
| "qData":{"title":"/qMetaDef/title","description":"/qMetaDef/description", | |
| "thumbnail":"/thumbnail","cells":"/cells","rank":"/rank","columns":"/columns","rows":"/rows"} | |
| } | |
| } |
erikwett
/ support_snapshot.js
Last active
December 5, 2017 13:24
Support snapshot in Qlik Sense extension
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // turn snapshot support on in your extension | |
| support: { | |
| snapshot: true, //snapshot - include in story | |
| export: true, //export to PDF, PowerPoint and image | |
| exportData: true //export data to excel | |
| } | |