In Chart

[rash_611]

Hi All,

i have a chart in Hour, Day, Month, Year Trend for total logged Calls. can i show the agent name instead of the value who have logged more calls as per the dimension.

Please find the attached image for reference.

Regards,

Grace

[kushalthakral]

Hi Grace

Can you please attach sample data file

Regards

Kushal Thakral

[#3]

Yes you can.

Try using the dual function in the Expression that calculates the total logged calls. Prior to that you will have to build an expression which returns the name of the agent with the max calls by hour.

So your expression should look something like -

Dual(Agent_expression, Current_Expression).

[kushalthakral]

Hi Grace

This is what you wanted in qlikview

[rash_611]

see for 1/1/2014 Madhura is topper and 2/1/2014 someother person... so i want the count and name of the topper person in chart...

[rash_611]

how do i do this... plz help me

[jagan]

Hi,

Add one more expression

=FirstSortedValue(Assignee, -Calls)

and Unselect Line in Expression tab and Select Values on Data Points option

Regards,

Jagan.

[rash_611]

FirstSortedValue(Assignee,count(DISTINCT {$<Link_Flag={'Arrival'}>} TicketID))

its giving null values...

[#9 · Accepted solution]

Please try attached document.

You should also aggregate the count over the Assignee and Call date.

Hope the attached document helps.

Regards,

SK

[jagan]

Hi,

FirstSortedValue(Assignee,-Aggr(Count({$<Link_Flag={'Arrival'}>} DISTINCT Call_Id),Assignee,Call_date))

Regards,

jagan.