topic Re: interval between rows in the same column / intervalo entre filas de la misma columna in QlikView

interval between rows in the same column / intervalo entre filas de la misma columna

Wed, 28 Sep 2011 12:50:51 GMT

Buenos días, necesito restar datos entre filas, es decir de una misma columna.

Hello, I need to subtract dates between rows, ie the same column.

Name	Time	State	Code
Person 1	01/01/2011 8:16:11	Logged - in	0
Person 1	01/01/2011 16:00:11	Logout	130

"Time"= 01/01/2011 16:00:11 - 01/01/2011 08:16:11 = 07:44:00

Necesito el restulado en horas de la resta

I need restulado in hours of rest

Soy novato, espero ayuda por favor, muchas gracias por todo

I'm newbie, I hope help please

thank you very much for everything

interval between rows in the same column / intervalo entre filas de la misma columna

swuehl — Wed, 28 Sep 2011 14:57:09 GMT

Hi,

I think you can try chart inter record functions like above, i.e. like this

= interval(Time- above(Time))

as expression in your chart. This will show the time difference between current and above row, for each row in your table.

Hope this helps,

Stefan

Re: interval between rows in the same column / intervalo entre filas de la misma columna

Thu, 29 Sep 2011 09:37:11 GMT

ok thanks :-).

ahora se complica un poco mas porque necesito condiciones.

now a little more complicated because I need conditions.

Name	Time	State	Code
Person 1	01/01/2011 8:16:11	Logged - in	0
Person 1	01/01/2011 16:00:11	Logout	23658

Person 1 01/01/2011 19:00:11 ready 44

Person 1 01/01/2011 19:00:11 Logout 130

Necesito el intervalo de "Time", SI "state"="Logged - in" y "Code"="130".

Need interval of "Time", if "state" = "Logged - in" and "Code" = "130"

Gracias

Thanks for your help

Re: interval between rows in the same column / intervalo entre filas de la misma columna

swuehl — Thu, 29 Sep 2011 17:30:07 GMT

Hi,

to create a time difference, you need to use two rows, so given your above example

- I don't see a matching row for state=Logged in" and Code=130

- If there is a match, to what other row should the interval difference be taken? Using the previous row or the previous row which matches the condition?

Could you provide maybe a more complete data sample (as INLINE table or sample qvw file) and the exprected results?

Regards,

Stefan