topic Re: Expression not showing values in QlikView https://community.qlik.com/t5/QlikView/Expression-not-showing-values/m-p/692800#M1065694 <HTML><HEAD></HEAD><BODY><P>Use NODISTINCT like:</P><P>=count(id)/sum(aggr(NODISTINCT count(id),PAIR))</P></BODY></HTML> Mon, 15 Sep 2014 04:25:01 GMT tresB 2014-09-15T04:25:01Z Expression not showing values https://community.qlik.com/t5/QlikView/Expression-not-showing-values/m-p/692799#M1065692 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please take a look at the attached example. What I can not figure out is why the Percentage expression only calculates for the first row of each row group. Here, rows are grouped by the "PAIR" values and are visually indicated by alternating background coloring.</P></BODY></HTML> Mon, 15 Sep 2014 04:12:16 GMT https://community.qlik.com/t5/QlikView/Expression-not-showing-values/m-p/692799#M1065692 2014-09-15T04:12:16Z Re: Expression not showing values https://community.qlik.com/t5/QlikView/Expression-not-showing-values/m-p/692800#M1065694 <HTML><HEAD></HEAD><BODY><P>Use NODISTINCT like:</P><P>=count(id)/sum(aggr(NODISTINCT count(id),PAIR))</P></BODY></HTML> Mon, 15 Sep 2014 04:25:01 GMT https://community.qlik.com/t5/QlikView/Expression-not-showing-values/m-p/692800#M1065694 tresB 2014-09-15T04:25:01Z