Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
johnnyjohn
Creator
Creator

Get minimum date per dimension for each row

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_0-1627565611391.png

johnnyjohn_1-1627565651599.png

 

3 Replies
Kushal_Chawda

@johnnyjohn  try below

=min(total <[Ord ID]> ChildTime)

johnnyjohn
Creator
Creator
Author

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  

Kushal_Chawda

@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])