Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Suppress Values in Pivot Table

Hi,

 

I have the following columns in my pivot chart:

 


Capture.JPG

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!

 

Labels (3)
1 Reply
Highlighted
Master II
Master II

create a field in the script

if(len(trim([Project End Date]))>0,0,1) as active_project_flag

use active_project_flag = 1 in the set analysis or in the if condition.
Learning never stops.