topic Re: How to Count the specific Values in the Column? in QlikView https://community.qlik.com/t5/QlikView/How-to-Count-the-specific-Values-in-the-Column/m-p/784814#M1036553 <HTML><HEAD></HEAD><BODY><P>No I just want to create a table and need to get the Total of NewCars and UsedCars.</P></BODY></HTML> Wed, 24 Dec 2014 04:33:08 GMT 2014-12-24T04:33:08Z How to Count the specific Values in the Column? https://community.qlik.com/t5/QlikView/How-to-Count-the-specific-Values-in-the-Column/m-p/784811#M1036549 <HTML><HEAD></HEAD><BODY><P>Hi QV Team,</P><P></P><P>I need to count only the "X' Values in the NewCars Column. Pls help me out. Pls see the attachments.</P></BODY></HTML> Wed, 24 Dec 2014 04:19:05 GMT https://community.qlik.com/t5/QlikView/How-to-Count-the-specific-Values-in-the-Column/m-p/784811#M1036549 2014-12-24T04:19:05Z Re: How to Count the specific Values in the Column? https://community.qlik.com/t5/QlikView/How-to-Count-the-specific-Values-in-the-Column/m-p/784812#M1036550 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Like this???</P><P>Thanks,<BR />AS</P></BODY></HTML> Wed, 24 Dec 2014 04:29:32 GMT https://community.qlik.com/t5/QlikView/How-to-Count-the-specific-Values-in-the-Column/m-p/784812#M1036550 amit_saini 2014-12-24T04:29:32Z Re: How to Count the specific Values in the Column? https://community.qlik.com/t5/QlikView/How-to-Count-the-specific-Values-in-the-Column/m-p/784813#M1036551 <HTML><HEAD></HEAD><BODY><P>Try this also:</P><P></P><P>count(if(match([New Cars],'X'),[New Cars]))</P><P></P><P>Thanks,</P><P>AS</P></BODY></HTML> Wed, 24 Dec 2014 04:31:41 GMT https://community.qlik.com/t5/QlikView/How-to-Count-the-specific-Values-in-the-Column/m-p/784813#M1036551 amit_saini 2014-12-24T04:31:41Z Re: How to Count the specific Values in the Column? https://community.qlik.com/t5/QlikView/How-to-Count-the-specific-Values-in-the-Column/m-p/784814#M1036553 <HTML><HEAD></HEAD><BODY><P>No I just want to create a table and need to get the Total of NewCars and UsedCars.</P></BODY></HTML> Wed, 24 Dec 2014 04:33:08 GMT https://community.qlik.com/t5/QlikView/How-to-Count-the-specific-Values-in-the-Column/m-p/784814#M1036553 2014-12-24T04:33:08Z Re: How to Count the specific Values in the Column? https://community.qlik.com/t5/QlikView/How-to-Count-the-specific-Values-in-the-Column/m-p/784815#M1036554 <HTML><HEAD></HEAD><BODY><P>Use count(if(match([New Cars],'X'),[New Cars])) than , you will get your result.</P><P></P><P>Thanks,<BR />AS</P></BODY></HTML> Wed, 24 Dec 2014 04:34:35 GMT https://community.qlik.com/t5/QlikView/How-to-Count-the-specific-Values-in-the-Column/m-p/784815#M1036554 amit_saini 2014-12-24T04:34:35Z Re: How to Count the specific Values in the Column? https://community.qlik.com/t5/QlikView/How-to-Count-the-specific-Values-in-the-Column/m-p/784816#M1036556 <HTML><HEAD></HEAD><BODY><P>Like this???</P><P>Thanks,</P><P>AS</P></BODY></HTML> Wed, 24 Dec 2014 04:39:01 GMT https://community.qlik.com/t5/QlikView/How-to-Count-the-specific-Values-in-the-Column/m-p/784816#M1036556 amit_saini 2014-12-24T04:39:01Z