topic Re: table in script in QlikView

table in script

fdelacal — Tue, 21 May 2013 11:44:12 GMT

i have a table like this

date room i neen to know how many room are occuped

start is day that enter the people to the room end when they go.

i need to know total.

thanks.

Gysbert_Wassenaar — Tue, 21 May 2013 11:47:54 GMT

T1:

LOAD *, rangesum(start,-end,peek(DateTotal)) as DateTotal

INLINE [

dateroom, start, end

05/04/2012, 3, 0

06/04/2012, 0, 0

07/04/2012, 0, 3

09/04/2012, 11, 0

10/04/2012, 0, 0

11/04/2012, 1, 1

12/04/2012, 0, 0

13/04/2012, 0, 0

14/04/2012, 0, 0

15/04/2012, 0, 9

16/04/2012, 3, 2

17/04/2012, 2, 1

];