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": "CustomButton", "settings": { "customButton": { "value": "" } }, "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 } 
]
Last updated on
Custom HtmlExamples