Count ID with Max(OutDate)

[Anonymous]

Hi All,

Hope someone is able to help me with this issue.

I have a table containing the below data:

ID	PartNo	PartNoOut	ReceivedDate	OutDate
303768	0-132-003900000	237015	2018-04-10 16:08:00.000	2018-05-31 16:12:42.567
303768	0-132-003900000	246110	2018-04-10 16:08:00.000	2018-08-28 13:17:09.173
303768	0-132-003900000	250246	2018-04-10 16:08:00.000	2018-05-31 16:12:42.567

I need to create a table in Qlik counting numbers of units out but using the MAX(OutDate). So the table in Qlik will show as the following:

Month/Year	Units Out
Oct-2018	1

As the ID is the same I only need to count this as one unit out.

Thanks in advance.

[OmarBenSalem]

First of all,

in the script create ur monthYear field as follow

Capitilize(Date(MonthStart(OutDate),'MMM-YYYY')) as MonthYear

Now in ur table, use

as dimension: MonthYear

as Measure: Count(distinct {<OutDate={"$(=max(total <ID> OutDate))"}>} PartNoOut)

Hope this helps !

[Anonymous]

Hi Omar,

I tried to add Capitilize(Date(MonthStart(OutDate),'MMM-YYYY')) as MonthYear into the script but this does not run due to the 'Capitilize()' section not being accepted.

Ignore it was just a spelling error. I have added everything as suggested but still get a result of 3.

[OmarBenSalem]

It capitalize; my bad lol