Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
is this qlikview or qliksense?
looks like qliksense
goto properties--Datahandling --un check include null values