QlikView PivotChart Expression problem

[sqlpuzzle]

Hi,

I need help with an expression to calculate % in a PivotChart.

The calculatuon is a division operation (Number of IDs in TeamB that Completed in 45 days over the Total number of TeamB IDs). by the Date Dimension.

Count(DISTINCT {$<Team={'TeamB'},DaysToComplete={"<=45"}>} ID)/Aggr(Count(DISTINCT {$<Team={'TeamB'}>}ID),day_month_year)

The expression is not showing the value in all scenarios. It seems to indicate a null.

What am I doing wrong?

Sample attached.

[MayilVahanan · Accepted solution]

HI @sqlpuzzle 

Try like below

=Count(DISTINCT {$<Team={'TeamB'},DaysToComplete={"<=45"}>} ID)/(Count(total<day_month_year> DISTINCT {$<Team={'TeamB'}>}ID))