Skip to Content
Data Plus TableCheat sheet

Unix time to Qlik date

=Date(Floor(Num#(Text(Num(ConvertToLocalTime(Timestamp((MakeDate(1970, 1, 1) + ([UnixDate]) / (1000 * 24 * 3600)))))))))

Unix time to Qlik timestamp

=Timestamp(Num#(Text(Num(ConvertToLocalTime(Timestamp((MakeDate(1970, 1, 1) + ([UnixDate]) / (1000 * 24 * 3600))))))))

In case your Qlik Cloud instance is located in a different timezone, the ConvertToLocalTime function has to be adjusted accordingly.

Expression:
=[Dimension1]
Additional Expression: 
Only({1}[Dimension2])
=aggr(only({<[FilterDimension]={'[FilterValue]'},[Dimension1]>}[Dimension1]),[Dimension1])

[FilterValue] examples

$(=GetFieldSelections([FilterDimension]))

Rules

Reload app with progress display

  • Requires a custom button, change the trigger accordingly
  • For Qlik Sense onPrem, change the action to Trigger task reload
[
{"trigger":{"id":"DataSaved","settings":{},"ruleValueOptions":[]},"condition":{},"actions":[{"id":"ReloadApp","settings":{"reload_partial":{"valueBool":false},"reload_weight":{"valueNum":1},"reload_variables":{"keyValueList":[]},"defaultResponseNotification":{"valueBool":true}}}],"enabled":true,"name":"Trigger reload","group":"Reload App","hideWarning":false},{"trigger":{"id":"ReloadTriggered","settings":{},"ruleValueOptions":[]},"condition":{"conditionBlock":{"type":"eval","invert":false,"eval":{"listSeperator":",","operator":"=","operator2":"=","value1":{"type":"reloadTriggered.status","data":{},"dataType":"string","hasColumn":false,"hasDbColumn":false,"hasDataType":false,"hasDateFormat":false,"hasQlikVariable":false,"hasValue":false,"hasIndex":false},"value2":{"type":"custom.static","data":{"value":"Triggered"},"dataType":"string","hasColumn":false,"hasDbColumn":false,"hasDataType":false,"hasDateFormat":false,"hasQlikVariable":false,"hasValue":true,"hasIndex":false}}}},"actions":[{"id":"ProgressDisplay","settings":{"progressDisplay_type":{"value":"Percent"},"progressDisplay_text":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"dataType":"string","value":"Reloading"}}},"progressDisplay_duration":{"ruleValue":{"type":"reloadTriggered.avgDuration","hasValue":false,"data":{"dataType":"string","value":""},"dataType":"number","hasColumn":false,"hasDbColumn":false,"hasDataType":false,"hasDateFormat":false,"hasQlikVariable":false,"hasIndex":false}},"progressDisplay_HideOnComplete":{"valueBool":false},"progressDisplay_icon":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"dataType":"string"}}},"progressDisplay_iconColor":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"dataType":"string"}}},"progressDisplay_round":{"valueBool":false},"progressDisplay_barColor":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"dataType":"string"}}}}}],"enabled":true,"name":"Show reload display","group":"Reload App","hideWarning":false},{"trigger":{"id":"AppReload","settings":{},"ruleValueOptions":[]},"condition":{},"actions":[{"id":"ProgressDisplay","settings":{"progressDisplay_type":{"value":"Hide"},"progressDisplay_text":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"dataType":"string","value":"Reloading"}}},"progressDisplay_duration":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"dataType":"string"}}},"progressDisplay_HideOnComplete":{"valueBool":false},"progressDisplay_icon":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"dataType":"string"}}},"progressDisplay_iconColor":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"dataType":"string"}}},"progressDisplay_round":{"valueBool":false},"progressDisplay_barColor":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"dataType":"string"}}}}}],"enabled":true,"name":"Hide Progress display on app reload","group":"Reload App","hideWarning":false}
]

File viewer dialog v3.8.0

IFrame dialog display of a file downloaded via the Data+ file connector.

  • Depending on your first trigger, the api call might not be row based and the result trigger has to be changed accordingly
  • The loading display is optional, downloads might take a bit
[
  {"trigger":{"id":"CellButtonClicked","settings":{"multiColumns":{"error":"Invalidsettings"}},"ruleValueOptions":[]},"condition":{},"actions":[{"id":"LoadingOverlay","settings":{"loadingOverlayId":{"value":"download_file"},"enableDisable":{"value":"Enable"},"value":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"dataType":"string"}}}}},{"id":"DP_API_Files","settings":{"apiId":{"value":"download_file"},"dp_apiKey":{"value":"","error":"Invalidsettings"},"api_files_type":{"value":"Download"},"file_path":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"value":"test/test.pdf"}}},"file_data":{"ruleValue":{"type":"file","data":{}}},"file_sourcePath":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"value":"folder/sourceFile.txt"}}},"file_destinationPath":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"value":"folder/destinationFile.txt"}}},"overwrite":{"valueBool":false},"defaultResponseNotification":{"valueBool":true},"file_downloadResponseType":{"value":"ObjectUrl"}}}],"enabled":true,"name":"Download file","group":"Fileviewerdialog","hideWarning":false},{"trigger":{"id":"ApiCallResultRow","settings":{"apiId":{"value":"download_file"}},"ruleValueOptions":[]},"condition":{},"actions":[{"id":"ShowDialog","settings":{"dialogType":{"value":"iframe"},"dialogTitle":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"dataType":"string"}}},"value":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"dataType":"string"}}},"customHtml":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"dataType":"string","value":""}}},"url":{"ruleValue":{"type":"apiData.data","hasValue":false,"data":{"dataType":"string"},"dataType":"string","hasColumn":false,"hasDbColumn":false,"hasDataType":false,"hasDateFormat":false,"hasQlikVariable":false,"hasIndex":false}},"dialogStyle":{},"autoClose":{"valueBool":false},"autoCloseTime":{}}},{"id":"LoadingOverlay","settings":{"enableDisable":{"value":"Disable"},"loadingOverlayId":{"value":"download_file"},"value":{"ruleValue":{"type":"custom.static","hasValue":true,"data":{"dataType":"string"}}}}}],"enabled":true,"name":"Show dialog","group":"Fileviewerdialog","hideWarning":false}
]

HTML

Simple image display

  • e.g. for rule show dialog (html)
  • $(img) can be a normal-/data- or object url
<div style="margin: auto; overflow: hidden;">
    <img src="$(img)" style="max-width: 100%; max-height: 100%" />
</div>
Last updated on
Custom HtmlExamples