topic Re: In Chart in QlikView https://community.qlik.com/t5/QlikView/In-Chart/m-p/713007#M256664 <HTML><HEAD></HEAD><BODY><P>FirstSortedValue(Assignee,count(DISTINCT {$&lt;Link_Flag={'Arrival'}&gt;} TicketID))</P><P></P><P></P><P>its giving null values...</P></BODY></HTML> Wed, 17 Sep 2014 05:12:39 GMT rash_611 2014-09-17T05:12:39Z In Chart https://community.qlik.com/t5/QlikView/In-Chart/m-p/713000#M256657 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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.</P><P></P><P>Please find the attached image for reference.</P><P></P><P>Regards,</P><P>Grace</P></BODY></HTML> Wed, 17 Sep 2014 04:09:29 GMT https://community.qlik.com/t5/QlikView/In-Chart/m-p/713000#M256657 rash_611 2014-09-17T04:09:29Z Re: In Chart https://community.qlik.com/t5/QlikView/In-Chart/m-p/713001#M256658 <HTML><HEAD></HEAD><BODY><P>Hi Grace </P><P></P><P>Can you please attach sample data file</P><P></P><P>Regards</P><P>Kushal Thakral</P></BODY></HTML> Wed, 17 Sep 2014 04:21:38 GMT https://community.qlik.com/t5/QlikView/In-Chart/m-p/713001#M256658 kushalthakral 2014-09-17T04:21:38Z Re: In Chart https://community.qlik.com/t5/QlikView/In-Chart/m-p/713002#M256659 <HTML><HEAD></HEAD><BODY><P>Yes you can.</P><P></P><P>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.</P><P></P><P>So your expression should look something like - </P><P>Dual(Agent_expression, Current_Expression).</P></BODY></HTML> Wed, 17 Sep 2014 04:40:18 GMT https://community.qlik.com/t5/QlikView/In-Chart/m-p/713002#M256659 2014-09-17T04:40:18Z Re: In Chart https://community.qlik.com/t5/QlikView/In-Chart/m-p/713003#M256660 <HTML><HEAD></HEAD><BODY><P>Hi Grace</P><P></P><P>This is what you wanted in qlikview</P><P><IMG alt="Untitled.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/66941_Untitled.jpg" style="width: 620px; height: 302px;" /></P></BODY></HTML> Wed, 17 Sep 2014 04:48:36 GMT https://community.qlik.com/t5/QlikView/In-Chart/m-p/713003#M256660 kushalthakral 2014-09-17T04:48:36Z Re: In Chart https://community.qlik.com/t5/QlikView/In-Chart/m-p/713004#M256661 <HTML><HEAD></HEAD><BODY><P><IMG alt="data.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/66919_data.jpg" /></P><P>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...</P></BODY></HTML> Wed, 17 Sep 2014 04:56:43 GMT https://community.qlik.com/t5/QlikView/In-Chart/m-p/713004#M256661 rash_611 2014-09-17T04:56:43Z Re: In Chart https://community.qlik.com/t5/QlikView/In-Chart/m-p/713005#M256662 <HTML><HEAD></HEAD><BODY><P>how do i do this... plz help me</P></BODY></HTML> Wed, 17 Sep 2014 04:58:39 GMT https://community.qlik.com/t5/QlikView/In-Chart/m-p/713005#M256662 rash_611 2014-09-17T04:58:39Z Re: In Chart https://community.qlik.com/t5/QlikView/In-Chart/m-p/713006#M256663 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Add one more expression</P><P></P><P></P><P>=FirstSortedValue(Assignee, -Calls)</P><P>and Unselect Line in Expression tab and Select Values on Data Points option</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 17 Sep 2014 05:05:18 GMT https://community.qlik.com/t5/QlikView/In-Chart/m-p/713006#M256663 jagan 2014-09-17T05:05:18Z Re: In Chart https://community.qlik.com/t5/QlikView/In-Chart/m-p/713007#M256664 <HTML><HEAD></HEAD><BODY><P>FirstSortedValue(Assignee,count(DISTINCT {$&lt;Link_Flag={'Arrival'}&gt;} TicketID))</P><P></P><P></P><P>its giving null values...</P></BODY></HTML> Wed, 17 Sep 2014 05:12:39 GMT https://community.qlik.com/t5/QlikView/In-Chart/m-p/713007#M256664 rash_611 2014-09-17T05:12:39Z Re: Re: In Chart https://community.qlik.com/t5/QlikView/In-Chart/m-p/713008#M256665 <HTML><HEAD></HEAD><BODY><P>Please try attached document. </P><P></P><P>You should also aggregate the count over the Assignee and Call date.</P><P>Hope the attached document helps.</P><P></P><P>Regards,</P><P>SK</P></BODY></HTML> Wed, 17 Sep 2014 05:28:39 GMT https://community.qlik.com/t5/QlikView/In-Chart/m-p/713008#M256665 2014-09-17T05:28:39Z Re: In Chart https://community.qlik.com/t5/QlikView/In-Chart/m-p/713009#M256666 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>FirstSortedValue(Assignee,-Aggr(Count({$&lt;Link_Flag={'Arrival'}&gt;} DISTINCT Call_Id),Assignee,Call_date))</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Wed, 17 Sep 2014 05:36:12 GMT https://community.qlik.com/t5/QlikView/In-Chart/m-p/713009#M256666 jagan 2014-09-17T05:36:12Z Re: In Chart https://community.qlik.com/t5/QlikView/In-Chart/m-p/713010#M256667 <HTML><HEAD></HEAD><BODY><P>Thanks a lot it worked... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 17 Sep 2014 06:26:20 GMT https://community.qlik.com/t5/QlikView/In-Chart/m-p/713010#M256667 rash_611 2014-09-17T06:26:20Z Re: In Chart https://community.qlik.com/t5/QlikView/In-Chart/m-p/713011#M256668 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Wed, 17 Sep 2014 06:28:34 GMT https://community.qlik.com/t5/QlikView/In-Chart/m-p/713011#M256668 rash_611 2014-09-17T06:28:34Z