topic Counting in QlikView https://community.qlik.com/t5/QlikView/Counting/m-p/235304#M86574 <HTML><HEAD></HEAD><BODY><P>Hi Asim,</P><P>see the attached example (latest entry by customer solved in the script).</P><P>Hope it gives you a new idea.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Thu, 11 Feb 2010 15:41:21 GMT 2010-02-11T15:41:21Z Counting https://community.qlik.com/t5/QlikView/Counting/m-p/235301#M86571 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>I would like to create a report for IBM Clear Quest software. Please check the excel file which has a raw data from IBM CQ database. What I want to do is to sort the action_timestamp field then count the "Kullanici_Testinde" value in the field of new_state. Would you please help me about it.</P><P>Best Regards,</P></BODY></HTML> Wed, 10 Feb 2010 08:45:03 GMT https://community.qlik.com/t5/QlikView/Counting/m-p/235301#M86571 2010-02-10T08:45:03Z Counting https://community.qlik.com/t5/QlikView/Counting/m-p/235302#M86572 <HTML><HEAD></HEAD><BODY><P>hi</P><P>attach is a file</P><P>with what you described</P><P>hope it helps</P></BODY></HTML> Wed, 10 Feb 2010 09:07:09 GMT https://community.qlik.com/t5/QlikView/Counting/m-p/235302#M86572 lironbaram 2010-02-10T09:07:09Z Counting https://community.qlik.com/t5/QlikView/Counting/m-p/235303#M86573 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Thanks for your prompt reply but I need more complicated solution. Let me clarify my request. I have replaced the date fields with timestamp in the excel file as you can see attached. What I want to do is to sort the id field first and timestamp field secondly. Then I would like to have the New_state value for the latest timestamp. Would you please send the sample file for this request. Thanks for your support.</P><P>Best Regards,</P><P></P><P>Asim Akin</P></BODY></HTML> Thu, 11 Feb 2010 15:27:50 GMT https://community.qlik.com/t5/QlikView/Counting/m-p/235303#M86573 2010-02-11T15:27:50Z Counting https://community.qlik.com/t5/QlikView/Counting/m-p/235304#M86574 <HTML><HEAD></HEAD><BODY><P>Hi Asim,</P><P>see the attached example (latest entry by customer solved in the script).</P><P>Hope it gives you a new idea.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Thu, 11 Feb 2010 15:41:21 GMT https://community.qlik.com/t5/QlikView/Counting/m-p/235304#M86574 2010-02-11T15:41:21Z