Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This should be possible.
You probably need some set analysis.
For eg:
Sum({$<status={1},date={"<=$(=max(date))"} }status)
Hope this helps.