Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Suppress Drill Down in Pivot Table when Dimension is null

Hello Guys,

I need to suppress dimension drill down when the child dimensions are null. I have created hierarchal data for project tasks some parent tasks have up to 5 children and some of them have 1-2 levels. I want to calculate the cost till the lowest level i.e; only if the child task exists.

Below is the image of the pivot table. In the below snapshot 1086 is the project number- General Requirements (Task-L1)-Sponsor (Task L2). I want to eliminate the null values under Sponsor (Task-L2) as there are no further tasks under it.

Any help in this regard is highly appreciated. 

Pivot.PNG

1 Reply
Highlighted
Champion III
Champion III

is this qlikview or qliksense?

looks like qliksense

goto properties--Datahandling --un check include null values