Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am trying to create a column that has the minimum timestamp for the dimension.
The dimension in my case is Ord ID.
So I try Aggr(Min(ChildTime),[Ord ID])
But I only get the minimum value (circled in red), for just one row.
Why is it only coming up for that one row? And how can I solve this?
@johnnyjohn try below
=min(total <[Ord ID]> ChildTime)
Thanks Kushal, this works in this context.
However, this only works as a measure, where as I think I need it to be a dimension, because I need to subtract another column from this value across all order IDs.
Does that make sense? Let me know if not and I will explain a bit more
@johnnyjohn If you want to perform any operation you can do it via measure, why do you need to have in calculation dimension? Calculated dimensions are resource consuming which you need to avoid it.
If you still want in dimension then expression which you are using should work, but try any of the below
aggr(min(total <[Ord ID]> ChildTime),[Ord ID])
aggr(nodistinct min(ChildTime),[Ord ID])