topic Re: Data aggregation in Expression in QlikView https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445638#M490586 <HTML><HEAD></HEAD><BODY><P>Why not just Fabs(Sum(Data)) ?</P></BODY></HTML> Wed, 26 Sep 2012 15:48:03 GMT whiteline 2012-09-26T15:48:03Z Data aggregation in Expression https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445635#M490583 <HTML><HEAD></HEAD><BODY><P>HI - </P><P></P><P>I am trying to aggregate/display my data by two dimensions </P><P></P><P>Dimension 1 - Location </P><P>Dimension 2&nbsp; -Region </P><P></P><P>Here is an example of my expression: </P><P></P><P>Fabs(Sum(Aggr(Sum(Data),[Location])))&amp; Fabs(Sum(Aggr(Sum(Data),[Region])))/100</P><P></P><P>What am I doing wrong? </P><P><BR />Thank you </P><P></P><P>Zhenya</P></BODY></HTML> Wed, 26 Sep 2012 15:16:35 GMT https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445635#M490583 2012-09-26T15:16:35Z Re: Data aggregation in Expression https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445636#M490584 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>It depends on what you're trying to achieve <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P><P>Where do you use this expression ?</P></BODY></HTML> Wed, 26 Sep 2012 15:29:57 GMT https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445636#M490584 whiteline 2012-09-26T15:29:57Z Re: Data aggregation in Expression https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445637#M490585 <HTML><HEAD></HEAD><BODY><P>I am using this as part of my cross tab table. </P><P></P><P>I want my table to display values that are only relevant to Location &amp; region. </P></BODY></HTML> Wed, 26 Sep 2012 15:37:49 GMT https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445637#M490585 2012-09-26T15:37:49Z Re: Data aggregation in Expression https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445638#M490586 <HTML><HEAD></HEAD><BODY><P>Why not just Fabs(Sum(Data)) ?</P></BODY></HTML> Wed, 26 Sep 2012 15:48:03 GMT https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445638#M490586 whiteline 2012-09-26T15:48:03Z Re: Data aggregation in Expression https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445639#M490587 <HTML><HEAD></HEAD><BODY><P>When i do that all values disappear from my table. </P></BODY></HTML> Wed, 26 Sep 2012 15:50:37 GMT https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445639#M490587 2012-09-26T15:50:37Z Re: Data aggregation in Expression https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445640#M490588 <HTML><HEAD></HEAD><BODY><P>It seems&nbsp; your data model differs from the one I've imagined.</P><P>Could you attach a screenshot with it?</P></BODY></HTML> Wed, 26 Sep 2012 15:59:39 GMT https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445640#M490588 whiteline 2012-09-26T15:59:39Z Re: Data aggregation in Expression https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445641#M490589 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="22563" class="jive-image-thumbnail jive-image" onclick="" alt="sample.png" src="https://community.qlik.com/legacyfs/online/22563_sample.png" width="450" /></P></BODY></HTML> Wed, 26 Sep 2012 17:10:40 GMT https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445641#M490589 2012-09-26T17:10:40Z Re: Data aggregation in Expression https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445642#M490590 <HTML><HEAD></HEAD><BODY><P>I mean Table viewer (Ctrl+T) screen shoot.</P></BODY></HTML> Wed, 26 Sep 2012 20:44:01 GMT https://community.qlik.com/t5/QlikView/Data-aggregation-in-Expression/m-p/445642#M490590 whiteline 2012-09-26T20:44:01Z