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))))))))Dropdown (Advanced) Expression
Expression:
=[Dimension1]
Additional Expression:
Only({1}[Dimension2])Dropdown (Advanced) Expression with Filter
=aggr(only({<[FilterDimension]={'[FilterValue]'},[Dimension1]>}[Dimension1]),[Dimension1])[FilterValue] examples
Qlik formula
$(=GetFieldSelections([FilterDimension]))Last updated on