Advanced expressions for text fields issue

[#1]

Hi guys,

I want to get a certain value in a text object, a day.

In a certain pie chart I show which day is the busiest day in hours, my expresion and dimension looks like:

DIMENSION

=if(match(TaskPerfMonth,'Jan','Feb','Mar', 'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'), TaskPerfWeekDay)

EXPRESION:

Sum({<operator={'AAA'}>} aggr(Sum(total_hours),Registration,TaskPerfDay,TaskPerfMonth)

/ if(GetSelectedCount(TaskPerfMonth)=0,12,GetSelectedCount(TaskPerfMonth)))

Now the pie charts shows me per the average amount of hours per week day within that year:

Now I want to show the Day with the highest value in a text object. Is this possible, if yes how would I do that?

[Kushal_Chawda]

Can you share the sample app?

[qlikviewwizard]

Hi,

Can you share the sample file to demonstrate your issue? Thank you.