topic Re: How to get the count? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595107#M1114668 <HTML><HEAD></HEAD><BODY><P>Hi Just give in Expression:</P><P>Count(distinct Field)</P><P></P><P>Thanks,</P></BODY></HTML> Mon, 17 Feb 2014 12:21:38 GMT amit_saini 2014-02-17T12:21:38Z How to get the count? https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595101#M1114662 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can anyone ;et me know Is it possible to create </P><P></P><P>How many organisations that I got in that working week and from which organisation the student is came?</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 17 Feb 2014 12:00:31 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595101#M1114662 2014-02-17T12:00:31Z Re: How to get the count? https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595102#M1114663 <HTML><HEAD></HEAD><BODY><P>use a pivot table? bar chart?</P></BODY></HTML> Mon, 17 Feb 2014 12:10:23 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595102#M1114663 2014-02-17T12:10:23Z Re: How to get the count? https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595103#M1114664 <HTML><HEAD></HEAD><BODY><P>Thanks and I did the same earlier but no use so I changed to Line. Is there any way to get this. Is the expression is correct which I used?</P></BODY></HTML> Mon, 17 Feb 2014 12:12:48 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595103#M1114664 2014-02-17T12:12:48Z Re: How to get the count? https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595104#M1114665 <HTML><HEAD></HEAD><BODY><P>Hi Amelia,</P><P></P><P>Use Pivot chart and you will be getting desired count the way you want.</P><P></P><P>Thanks,</P></BODY></HTML> Mon, 17 Feb 2014 12:13:54 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595104#M1114665 amit_saini 2014-02-17T12:13:54Z Re: How to get the count? https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595105#M1114666 <HTML><HEAD></HEAD><BODY><P>Thanks and my user wants to see the data in graph.any solution please?</P></BODY></HTML> Mon, 17 Feb 2014 12:15:28 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595105#M1114666 2014-02-17T12:15:28Z Re: How to get the count? https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595106#M1114667 <HTML><HEAD></HEAD><BODY><P>well i should use a bar chart then.</P><P></P><P>You can see count per organization</P></BODY></HTML> Mon, 17 Feb 2014 12:21:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595106#M1114667 2014-02-17T12:21:04Z Re: How to get the count? https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595107#M1114668 <HTML><HEAD></HEAD><BODY><P>Hi Just give in Expression:</P><P>Count(distinct Field)</P><P></P><P>Thanks,</P></BODY></HTML> Mon, 17 Feb 2014 12:21:38 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595107#M1114668 amit_saini 2014-02-17T12:21:38Z Re: How to get the count? https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595108#M1114672 <HTML><HEAD></HEAD><BODY><P>Thanks and I used the same but it is showing very small bars and more bars so the bar is not clear.</P><P></P><P>I have to show the trends of data. Is it possible with below expression?</P><P></P><P>avg({&lt;Week={"&lt;=$(Max(Week))"},Week={"&gt;$(=max(Week)-1)"}&gt;} StudentID)</P></BODY></HTML> Mon, 17 Feb 2014 12:25:56 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595108#M1114672 2014-02-17T12:25:56Z Re: How to get the count? https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595109#M1114674 <HTML><HEAD></HEAD><BODY><P>Any help please?</P></BODY></HTML> Mon, 17 Feb 2014 13:22:07 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-count/m-p/595109#M1114674 2014-02-17T13:22:07Z