Set Analysis to count max dates in a row

german_avanzato — Sat, 05 Jul 2014 03:08:11 GMT

Hi everyone:

I am trying to achieve something with a set analysis but I cant get the right result.

What i am trying to do, is count the max days (Fecha, fomat DD/MM/YYYY) in a row that a player (NomApellido) has played a Match of soccer.

We play every 7 days, so if Fecha - Previuos (Fecha) = 7, then is a consecutive match.

If Juega = 1, it means the player have played the match.

In the example attached, the correct result are in the chart named "Test" where I use a calculated dimmension.

In the chart named "Analysis" is the set analysis that i try to do but it isnt working.

Ej: Fernando Herrero played 12 matches in a row, not 10.

The end result must be like the one in the chart "Analysis".

I can solve this in the load script, but I want to do it with a set analysis

Thanks everyone

PD : the information is order by date (Fecha)

topic Set Analysis to count max dates in a row in QlikView