Advanced expressions for text fields issue

Fri, 04 Sep 2015 12:28:05 GMT

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?

Re: Advanced expressions for text fields issue

Kushal_Chawda — Fri, 04 Sep 2015 12:38:48 GMT

Can you share the sample app?

qlikviewwizard — Sun, 06 Sep 2015 02:29:41 GMT

Hi,

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