Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to generate a bell curve based with a value derived from the following function:
.2*count(distinct [Office Code])/Max({<[Product Code]>} total Aggr(count(distinct {1} [Office Code]), [Product Code])) +
if
count(distinct{<[Fiscal Year]={$(=MAX({<[Product Code]>}[Fiscal Year]))}>} [Contract Number])>
count(distinct{ <[Fiscal Year]={$(=MIN({<[Product Code]>}[Fiscal Year]))}>} [Contract Number])
and MAX([Fiscal Year])> MIN([Fiscal Year]),
'0.08', '0'
)
I found this thread: https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Histogram/ba-p/1462688
and when I try to replace the "Value"s in the equation from the above link with my equation I get a nested aggregation error.
Edit:
I've corrected the nested aggregation error, but now I'm having issues displaying the chart. All of my bars appear to be summing all the scores instead of just showing that individual product code's score.
Editted OP with an updated question