Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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?

Tags (1)
2 Replies

Re: Advanced expressions for text fields issue

Can you share the sample app?

Arjunarao
Honored Contributor II

Re: Advanced expressions for text fields issue

Hi,

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

Community Browser