topic Re: Display min date value based on aggr with id field in QlikView

Display min date value based on aggr with id field

Marcushenriquesk — Wed, 13 Apr 2022 16:03:57 GMT

Working on a dashboard, one of the visual tools I'm using is a table. It has a few fields displayed as dimensions. But, I want to add a measure which will display the min date (RECEIVED_DATE) per each value in the field 'LOC_ID'.

Here is my attempt but only null values show:

=min(aggr(RECEIVED_DATE,[LOC_ID-Location ID]))

Re: Display min date value based on aggr with id field

hic — Thu, 14 Apr 2022 07:26:33 GMT

The reason could be that there are more than one RECEIVED_DATE per [LOC_ID-Location ID]. If so, you need to specify which RECEIVED_DATE to choose. Try

Min(Aggr(Min(RECEIVED_DATE),[LOC_ID-Location ID]))

Re: Display min date value based on aggr with id field

Marcushenriquesk — Thu, 14 Apr 2022 13:34:51 GMT

still only displaying null values when i tried using that function.

Re: Display min date value based on aggr with id field

hic — Thu, 14 Apr 2022 13:52:11 GMT

There could be a number of other causes: Incorrect date interpretation of RECEIVED_DATE; no connection between RECEIVED_DATE and [LOC_ID-Location ID]; no field called [LOC_ID-Location ID], etc.

But it is not possible to tell from what you have written above. You need to give us a little more information.

Re: Display min date value based on aggr with id field

Marcushenriquesk — Thu, 14 Apr 2022 14:45:51 GMT

okay sure, so LOC_ID is the primary key of a table called locations. The host of information on that table is a lot of demographics regarding the locations we have as clients. The received date is part of a table called requisitions. the primary key of that table being acc_ID. for each ACC_ID there is a received date and each acc_id has a loc_id that is the association of what location we got the requisition from. Recieved_date is formatted as MM/DD/yyyy and is derived and tagged with #$date. each Location has a acc_id that has a received date that is the 'first'/ minimum requisition we received from that location. the purpose of this measure is to show the date of the first received ACC_ID per each loc_id

Re: Display min date value based on aggr with id field

Marcushenriquesk — Fri, 15 Apr 2022 15:16:03 GMT

the issue was not solved