topic Re: Price in each row in QlikView https://community.qlik.com/t5/QlikView/Price-in-each-row/m-p/428443#M489972 <HTML><HEAD></HEAD><BODY><P>yuhuuuuuuuuuuuuuuuu</P><P>Thats right.</P><P>tnx so much<IMG src="https://community.qlik.com/legacyfs/online/emoticons/love.png" /></P></BODY></HTML> Tue, 13 Nov 2012 13:50:24 GMT 2012-11-13T13:50:24Z Price in each row https://community.qlik.com/t5/QlikView/Price-in-each-row/m-p/428441#M489970 <HTML><HEAD></HEAD><BODY><P>Hi friends,</P><P>I want to access to 1,414,921,650 value in each row.</P><P>but only i see it in one row and total row.</P><P>what can i do?</P><P></P><P><IMG __jive_id="25031" class="jive-image-thumbnail jive-image" onclick="" alt="Pivot_02.jpg" src="https://community.qlik.com/legacyfs/online/25031_Pivot_02.jpg" width="450" /></P></BODY></HTML> Tue, 13 Nov 2012 12:56:08 GMT https://community.qlik.com/t5/QlikView/Price-in-each-row/m-p/428441#M489970 2012-11-13T12:56:08Z Re: Price in each row https://community.qlik.com/t5/QlikView/Price-in-each-row/m-p/428442#M489971 <HTML><HEAD></HEAD><BODY><P>Well, how are we supposed to help here? </P><P>It would really help us to help you if you could tell us the expression you are using, unless you want us to start wild guessing (some other information about your data model etc might also help).</P><P></P><P>Maybe you do, so I assume you are using an advanced aggregation in your expression (i.e. the aggr() function).</P><P>As I said, just guessing.</P><P></P><P>Try adding a NODISTINCT qualifier to the aggr() function, like sum(aggr( NODISTINCT sum(FIELD), DIMFIELD1, DIMFIELD2))</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Tue, 13 Nov 2012 13:41:06 GMT https://community.qlik.com/t5/QlikView/Price-in-each-row/m-p/428442#M489971 swuehl 2012-11-13T13:41:06Z Re: Price in each row https://community.qlik.com/t5/QlikView/Price-in-each-row/m-p/428443#M489972 <HTML><HEAD></HEAD><BODY><P>yuhuuuuuuuuuuuuuuuu</P><P>Thats right.</P><P>tnx so much<IMG src="https://community.qlik.com/legacyfs/online/emoticons/love.png" /></P></BODY></HTML> Tue, 13 Nov 2012 13:50:24 GMT https://community.qlik.com/t5/QlikView/Price-in-each-row/m-p/428443#M489972 2012-11-13T13:50:24Z