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}
]
Last updated on
Custom HtmlExamples