topic Re: Calculate a no of rows in the straight table whose color is green and want calculate that count of no of rows in to another graph in QlikView https://community.qlik.com/t5/QlikView/Calculate-a-no-of-rows-in-the-straight-table-whose-color-is/m-p/953130#M960837 <HTML><HEAD></HEAD><BODY><P>hi</P><P>please post sample data with desired requirement.</P></BODY></HTML> Mon, 26 Oct 2015 06:07:47 GMT mightyqlikers 2015-10-26T06:07:47Z Calculate a no of rows in the straight table whose color is green and want calculate that count of no of rows in to another graph https://community.qlik.com/t5/QlikView/Calculate-a-no-of-rows-in-the-straight-table-whose-color-is/m-p/953128#M960835 <HTML><HEAD></HEAD><BODY><P>I have one straight table in which I have red,green and yellow colors of row.</P><P>I want to calculate the count of the no of rows whose color is green and the total no of rows.</P><P>and want to calculate Count(no of rows whose color is green) / Count(no of rows whose color is green,red,yellow).</P><P>And Want to calculate that expression in to the bar chart with the formula</P><P><SPAN style="font-size: 13.3333px;">Count(no of rows whose color is green) / Count(no of rows whose color is green,red,yellow).</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Fri, 23 Oct 2015 14:06:01 GMT https://community.qlik.com/t5/QlikView/Calculate-a-no-of-rows-in-the-straight-table-whose-color-is/m-p/953128#M960835 2015-10-23T14:06:01Z Re: Calculate a no of rows in the straight table whose color is green and want calculate that count of no of rows in to another graph https://community.qlik.com/t5/QlikView/Calculate-a-no-of-rows-in-the-straight-table-whose-color-is/m-p/953129#M960836 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>how do you get the colors (green,red, yellow)? if it is your expression background color, then you can use same expression for your other calculation.</P></BODY></HTML> Mon, 26 Oct 2015 04:00:23 GMT https://community.qlik.com/t5/QlikView/Calculate-a-no-of-rows-in-the-straight-table-whose-color-is/m-p/953129#M960836 settu_periasamy 2015-10-26T04:00:23Z Re: Calculate a no of rows in the straight table whose color is green and want calculate that count of no of rows in to another graph https://community.qlik.com/t5/QlikView/Calculate-a-no-of-rows-in-the-straight-table-whose-color-is/m-p/953130#M960837 <HTML><HEAD></HEAD><BODY><P>hi</P><P>please post sample data with desired requirement.</P></BODY></HTML> Mon, 26 Oct 2015 06:07:47 GMT https://community.qlik.com/t5/QlikView/Calculate-a-no-of-rows-in-the-straight-table-whose-color-is/m-p/953130#M960837 mightyqlikers 2015-10-26T06:07:47Z Re: Calculate a no of rows in the straight table whose color is green and want calculate that count of no of rows in to another graph https://community.qlik.com/t5/QlikView/Calculate-a-no-of-rows-in-the-straight-table-whose-color-is/m-p/953131#M960838 <HTML><HEAD></HEAD><BODY><P>As Settu suggested, use the color coding expression to get the count..</P></BODY></HTML> Mon, 26 Oct 2015 06:44:06 GMT https://community.qlik.com/t5/QlikView/Calculate-a-no-of-rows-in-the-straight-table-whose-color-is/m-p/953131#M960838 PradeepReddy 2015-10-26T06:44:06Z