Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
orangebloss
Creator
Creator

Combo charts : Hiding dimension value when measure not calculated

In my combo chart the measures only calculate if there are any late values (shown in red below) using the format :

if(Sum({<SevenDayTaskCompletionTimeStatus = {"Overdue","Late to Milestone"},TaskName-={TaskName1}>} EstimateHours)/

Sum(EstimateHours)>0,
Sum({<SevenDayTaskCompletionTimeStatus = {"Overdue","Late to Milestone"},TaskName-={TaskName1}>} EstimateHours)/

Sum(EstimateHours))

and substituting the measure to be calculated with the other status (e.g. Complete). I'd like to hide any of the dimension values where the calculation is not performed and leaves a blank space. Currently my dimension is created using the following :

if(ProjectId='556802'and TaskListId<>'2206984' and TaskProjectType='CME',


TaskName1)

 

I've tried calculating if the count or sum of the SevenDayTaskCompletionTimeStatus >0 and adding that to the dimension but this doesn't work. The data is built using the hierarchy function - TaskName1 is the task displayed on the bottom of the chart and the calculations are done on everything that is not TaskName1 (i.e. everything below it).

 

Help appreciated!

 

 

orangebloss_0-1744206459724.png

 

Labels (4)
0 Replies