status count

[#1]

hi all

i am here with a big and complex issues but i believe the qlikview gurus could help me

at the excel i want to chose a DEPARTMENT and DATE  and  i will check the status and  then

i will count that in how many days  my status is same.

for example if i select 12.07.2012 and department a (row 13 in excel) it will give me 6 days,

the status is 1.

for example if i select 15.07.2012 and department a (row 16 in excel) it will give me 9 days,

the status is 1.

for example if i select 24.07.2012 and department a (row 25 in excel) it will give me 8 days,

the status is 0.

thanks

[#2]

This should be possible.

You probably need some set analysis.

For eg:

Sum({$<status={1},date={"<=$(=max(date))"} }status)

Hope this helps.