topic Re: Group By function in Expresssion in QlikView https://community.qlik.com/t5/QlikView/Group-By-function-in-Expresssion/m-p/379552#M494769 <HTML><HEAD></HEAD><BODY><P>This should give you the 5000 in your total for Nation Volume:</P><P></P><P><EM>=Sum( aggr( sum(Value), Territory,Zip))</EM></P><P></P><P>Not sure what you want to see at the details level, so you may want to use a differnt expression for that dimensionality:</P><P></P><P><EM>=if(dimensionality()=0,</EM></P><P><EM>Sum( aggr( sum(Value), Territory,Zip)),</EM></P><P><EM>YourDetailsLevelsExpressionGoesHere</EM></P><P><EM>)</EM></P></BODY></HTML> Tue, 21 Aug 2012 13:25:31 GMT swuehl 2012-08-21T13:25:31Z Group By function in Expresssion https://community.qlik.com/t5/QlikView/Group-By-function-in-Expresssion/m-p/379551#M494768 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a situation where I need to show sum of the value for nation.</P><P></P><P>My fact is at ZIP level but at nation level I want sum up the data from territory level.</P><P></P><P>Basically I want see the value for 'Nation Volume' column as 5000 (refer attached QVW)</P><P></P><P>It would be great if any one help me on this.</P><P></P><P>Thanks,</P><P>Om.</P></BODY></HTML> Tue, 21 Aug 2012 13:09:16 GMT https://community.qlik.com/t5/QlikView/Group-By-function-in-Expresssion/m-p/379551#M494768 2012-08-21T13:09:16Z Re: Group By function in Expresssion https://community.qlik.com/t5/QlikView/Group-By-function-in-Expresssion/m-p/379552#M494769 <HTML><HEAD></HEAD><BODY><P>This should give you the 5000 in your total for Nation Volume:</P><P></P><P><EM>=Sum( aggr( sum(Value), Territory,Zip))</EM></P><P></P><P>Not sure what you want to see at the details level, so you may want to use a differnt expression for that dimensionality:</P><P></P><P><EM>=if(dimensionality()=0,</EM></P><P><EM>Sum( aggr( sum(Value), Territory,Zip)),</EM></P><P><EM>YourDetailsLevelsExpressionGoesHere</EM></P><P><EM>)</EM></P></BODY></HTML> Tue, 21 Aug 2012 13:25:31 GMT https://community.qlik.com/t5/QlikView/Group-By-function-in-Expresssion/m-p/379552#M494769 swuehl 2012-08-21T13:25:31Z