topic Re: Straight Table with Counts in QlikView https://community.qlik.com/t5/QlikView/Straight-Table-with-Counts/m-p/1263436#M398282 <HTML><HEAD></HEAD><BODY><P>I just realized that I had a typo in my expression. I was surprised it wasn't working. Thank you for your reply.</P></BODY></HTML> Thu, 09 Mar 2017 20:01:47 GMT evansabres 2017-03-09T20:01:47Z Straight Table with Counts https://community.qlik.com/t5/QlikView/Straight-Table-with-Counts/m-p/1263434#M398280 <HTML><HEAD></HEAD><BODY><P>I am looking to create a straight table for my field JobStatus.</P><P></P><P>I want the dimension to be JobStatus and the expressions to be counts of the occurrences of different values in this field such as 'Awaiting Approval'</P><P></P><P>I am struggling with the expression.</P></BODY></HTML> Thu, 09 Mar 2017 19:55:20 GMT https://community.qlik.com/t5/QlikView/Straight-Table-with-Counts/m-p/1263434#M398280 evansabres 2017-03-09T19:55:20Z Re: Straight Table with Counts https://community.qlik.com/t5/QlikView/Straight-Table-with-Counts/m-p/1263435#M398281 <HTML><HEAD></HEAD><BODY><P>Hi Evan,</P><P>With JobStatus as a dimension, just Count(JobStatus) as expression.</P><P>Regards,</P><P>H</P></BODY></HTML> Thu, 09 Mar 2017 20:00:03 GMT https://community.qlik.com/t5/QlikView/Straight-Table-with-Counts/m-p/1263435#M398281 hector_munoz 2017-03-09T20:00:03Z Re: Straight Table with Counts https://community.qlik.com/t5/QlikView/Straight-Table-with-Counts/m-p/1263436#M398282 <HTML><HEAD></HEAD><BODY><P>I just realized that I had a typo in my expression. I was surprised it wasn't working. Thank you for your reply.</P></BODY></HTML> Thu, 09 Mar 2017 20:01:47 GMT https://community.qlik.com/t5/QlikView/Straight-Table-with-Counts/m-p/1263436#M398282 evansabres 2017-03-09T20:01:47Z Re: Straight Table with Counts https://community.qlik.com/t5/QlikView/Straight-Table-with-Counts/m-p/1263437#M398283 <HTML><HEAD></HEAD><BODY><P>Your Dimension will be JobStatus and expression should be count(JobID), ID/Key filed available in the table.</P><P></P><P>Share some sample data to check.</P></BODY></HTML> Thu, 09 Mar 2017 20:03:10 GMT https://community.qlik.com/t5/QlikView/Straight-Table-with-Counts/m-p/1263437#M398283 krishnacbe 2017-03-09T20:03:10Z