Text Box Calculation

tmumaw — Sat, 16 Nov 2024 02:52:16 GMT

Morning everyone,

I have a text object which does a calculation, and below the text object I have a straight table which ranks the average number of days from low to high. The ranking in the straight table starts at 2 - 10. The text object is the number 1. For some reason it's coming up negative, and yes there is an negative sign before the average so it can sort in the correct order. I need to get rid of the negative sign. Here is the calculation I'm using.

=' Top - ' &FirstSortedValue(distinct Recruit_Mgr, -Aggr(-avg({<Closed = {1}>}Age),Recruit_Mgr)) & ' - '& Max(Num(aggr(-avg({<Closed = {1}>}Age) ,[Recruit_Mgr] ),'#,##0') )

Re: Text Box Calculation

tmumaw — Tue, 30 Jul 2019 11:35:04 GMT

Figured it out. Should have been a min not a max.

=' Top - ' &FirstSortedValue(distinct Recruit_Mgr, -Aggr(-avg({<Closed = {1}>}Age),Recruit_Mgr)) & ' - '& Min(Num(aggr(avg({<Closed = {1}>}Age) ,[Recruit_Mgr] ),'#,##0'))

topic Text Box Calculation in QlikView

Text Box Calculation

Re: Text Box Calculation