Show count last value by dimension graph

daniel_martin_a — Sat, 16 Nov 2024 02:16:29 GMT

Hi to all.

I need show count of incident by month and last phase for this month and incident.

Please, I attach a little example of this problem (because I try some aggr and not found the solution) to help me.

On this example, I want obtain on YearMonth = 201910 the values phase = 3 then 1 and phase = 4 then 1, but obtain other values (first phase by Incident and YearMonth, phase 2 and phase 3, I want last phase). Rest of months are ok in this example.

Please, can you help me.

Thanks.

Regards.

Re: Show count last value by dimension graph

daniel_martin_a — Wed, 09 Oct 2019 10:51:12 GMT

I answer me.

=count(
AGGR(
if(MaxString(TOTAL <ID,YearMonth>
Aggr(MaxString( ID & '%' & Phase),ID,YearMonth)) =
ID & '%' & Phase,
ID) ,
ID,YearMonth,Phase)
)

Thanks.

topic Show count last value by dimension graph in QlikView

Show count last value by dimension graph

Re: Show count last value by dimension graph