QlikView PivotChart Expression problem

sqlpuzzle — Tue, 09 Feb 2021 03:01:42 GMT

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.

Re: QlikView PivotChart Expression problem

MayilVahanan — Tue, 09 Feb 2021 03:50:20 GMT

Try like below

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