Discussion board where members can get started with QlikView.
I have the following columns in my pivot chart:
I have a filter called ActiveProjects applied on this chart. This column is calculated on the basis of ProjectStage.
An 'active' project might still be in-progress, but a resource could have stopped working on it. The ProjectEndDate column in the above datasheet is actually the Resource End Date for that project.
My requirement is that when ActiveProjects filter is selected, all the projects where there is an EndDate should be removed.
Can this be done? Any help would be appreciated!