topic Re: aggr suppresing a row in QlikView https://community.qlik.com/t5/QlikView/aggr-suppresing-a-row/m-p/393654#M146776 <HTML><HEAD></HEAD><BODY><P>that worked thanks .. but no idea why it worked!!!.&nbsp; because the dimension (item )are not similar in any way ...</P><P>so my expression should have returned that suppressed row . </P></BODY></HTML> Tue, 09 Oct 2012 11:29:06 GMT 2012-10-09T11:29:06Z aggr suppresing a row https://community.qlik.com/t5/QlikView/aggr-suppresing-a-row/m-p/393652#M146774 <HTML><HEAD></HEAD><BODY><P>Hi Everyone ,</P><P>I created a pivot chart with a aggr expression . What is happening is by default without any selection it is suppressing the rows . But whenever i select a item it gives me the right answer .Any one has any idea why this happens .</P><P></P><P></P><P>thanks..</P></BODY></HTML> Tue, 09 Oct 2012 10:49:30 GMT https://community.qlik.com/t5/QlikView/aggr-suppresing-a-row/m-p/393652#M146774 2012-10-09T10:49:30Z Re: aggr suppresing a row https://community.qlik.com/t5/QlikView/aggr-suppresing-a-row/m-p/393653#M146775 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>That is what teh Aggr() function is expected to do. Use instead</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13497803191316760" jivemacro_uid="_13497803191316760"><P>Aggr(NODISTINCT <EM>expressionhere</EM>)</P></PRE><P></P><P>and you should see all values in all rows, repeating when required.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Tue, 09 Oct 2012 10:59:00 GMT https://community.qlik.com/t5/QlikView/aggr-suppresing-a-row/m-p/393653#M146775 Miguel_Angel_Baeyens 2012-10-09T10:59:00Z Re: aggr suppresing a row https://community.qlik.com/t5/QlikView/aggr-suppresing-a-row/m-p/393654#M146776 <HTML><HEAD></HEAD><BODY><P>that worked thanks .. but no idea why it worked!!!.&nbsp; because the dimension (item )are not similar in any way ...</P><P>so my expression should have returned that suppressed row . </P></BODY></HTML> Tue, 09 Oct 2012 11:29:06 GMT https://community.qlik.com/t5/QlikView/aggr-suppresing-a-row/m-p/393654#M146776 2012-10-09T11:29:06Z