topic Formula in Chart in QlikView https://community.qlik.com/t5/QlikView/Formula-in-Chart/m-p/663800#M241774 <HTML><HEAD></HEAD><BODY><P>Hi geniuses,</P><P></P><P>I Have a chart belo which have Entity and Time as dimension and I am using the formula =aggr(Count(Entity),Time) but it is not giving me desired result . if you see there are time coming as two times 07 one time 08 one time 13 and 5 times 17 but what I want that 07 will come only one time with count of 2 08 count should be 1 13 count should be 1 and 17 count should be 5 . Actually I want to track during which time of the day user login is most on particular entity</P><P></P><P>Please help me</P><P></P><P>Thanks in advance</P><P></P><P></P><P></P><P></P><P>Shashank<IMG alt="Chart.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/64220_Chart.jpg" style="width: 620px; height: 388px;" /></P></BODY></HTML> Tue, 12 Aug 2014 09:58:27 GMT Anonymous 2014-08-12T09:58:27Z Formula in Chart https://community.qlik.com/t5/QlikView/Formula-in-Chart/m-p/663800#M241774 <HTML><HEAD></HEAD><BODY><P>Hi geniuses,</P><P></P><P>I Have a chart belo which have Entity and Time as dimension and I am using the formula =aggr(Count(Entity),Time) but it is not giving me desired result . if you see there are time coming as two times 07 one time 08 one time 13 and 5 times 17 but what I want that 07 will come only one time with count of 2 08 count should be 1 13 count should be 1 and 17 count should be 5 . Actually I want to track during which time of the day user login is most on particular entity</P><P></P><P>Please help me</P><P></P><P>Thanks in advance</P><P></P><P></P><P></P><P></P><P>Shashank<IMG alt="Chart.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/64220_Chart.jpg" style="width: 620px; height: 388px;" /></P></BODY></HTML> Tue, 12 Aug 2014 09:58:27 GMT https://community.qlik.com/t5/QlikView/Formula-in-Chart/m-p/663800#M241774 Anonymous 2014-08-12T09:58:27Z Re: Formula in Chart https://community.qlik.com/t5/QlikView/Formula-in-Chart/m-p/663801#M241775 <HTML><HEAD></HEAD><BODY><P>Guys please help me please</P></BODY></HTML> Tue, 12 Aug 2014 11:10:23 GMT https://community.qlik.com/t5/QlikView/Formula-in-Chart/m-p/663801#M241775 Anonymous 2014-08-12T11:10:23Z Re: Formula in Chart https://community.qlik.com/t5/QlikView/Formula-in-Chart/m-p/663802#M241776 <HTML><HEAD></HEAD><BODY><P>Do you have a qvw document you can attach?</P></BODY></HTML> Tue, 12 Aug 2014 11:26:08 GMT https://community.qlik.com/t5/QlikView/Formula-in-Chart/m-p/663802#M241776 c_gilbert 2014-08-12T11:26:08Z Re: Formula in Chart https://community.qlik.com/t5/QlikView/Formula-in-Chart/m-p/663803#M241777 <HTML><HEAD></HEAD><BODY><P>Hi Shashank,</P><P></P><P>It seems that there are different values for the same time, in script try to set <EM>Text(Time) as Time</EM></P><P></P><P>Different seconds, minutes or date may brign same hour but different internal values.</P><P></P><P>Hope this helps</P></BODY></HTML> Tue, 12 Aug 2014 11:28:51 GMT https://community.qlik.com/t5/QlikView/Formula-in-Chart/m-p/663803#M241777 rubenmarin 2014-08-12T11:28:51Z Re: Formula in Chart https://community.qlik.com/t5/QlikView/Formula-in-Chart/m-p/663804#M241778 <HTML><HEAD></HEAD><BODY><P>You are a life saver thanks alot <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 12 Aug 2014 12:23:58 GMT https://community.qlik.com/t5/QlikView/Formula-in-Chart/m-p/663804#M241778 Anonymous 2014-08-12T12:23:58Z