Suppress Values in Pivot Table

yashcena — Sat, 16 Nov 2024 21:28:11 GMT

Hi,

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!

Re: Suppress Values in Pivot Table

pradosh_thakur — Tue, 05 Feb 2019 08:18:46 GMT

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.

topic Suppress Values in Pivot Table in QlikView

Suppress Values in Pivot Table

Re: Suppress Values in Pivot Table