status count

Fri, 24 Aug 2012 07:55:32 GMT

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

Re: status count

Fri, 24 Aug 2012 10:52:48 GMT

This should be possible.

You probably need some set analysis.

For eg:

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

Hope this helps.