Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Advanced expressions for text fields issue

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:

test.png

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?

2 Replies
Kushal_Chawda

Can you share the sample app?

qlikviewwizard
Master II
Master II

Hi,

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