Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
johnnyjohn
Contributor III
Contributor III

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
Contributor III
Contributor III
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])