topic Re: Issue with aggr function and dimension in QlikView https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21107#M771522 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>I couldn't get this line, What do you mean by this?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM><STRONG>But i dont want my numbers to change i need that to be same as we see above</STRONG></EM></SPAN></P></BODY></HTML> Mon, 28 May 2018 15:03:54 GMT shiveshsingh 2018-05-28T15:03:54Z Issue with aggr function and dimension https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21106#M771521 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P><A href="https://community.qlik.com/qlik-users/246322" target="_blank">stalwar123</A>‌</P><P></P><P>When i have only 1 dimension(FRCA_WeekYear as Dimension) and with below one expression</P><P></P><P>Count(Count(TOTAL DISTINCT Aggr(Customer,FRCA_WeekYear)))</P><P></P><P>i see below in my pivot.. Which is fine..</P><P></P><P><IMG alt="Capture1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/203699_Capture1.PNG" style="height: auto;" /></P><P></P><P>When i add one more dimension to this (Calc_FRCA_FR_Category), my number changes as per the addtnl dimension... which is fine... But i dont want my numbers to change i need that to be same as we see above.. Is it possible?</P><P></P><P><IMG alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/203700_Capture1.PNG" style="height: 626px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21106#M771521 ramanarayan 2020-11-25T16:16:04Z Re: Issue with aggr function and dimension https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21107#M771522 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>I couldn't get this line, What do you mean by this?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM><STRONG>But i dont want my numbers to change i need that to be same as we see above</STRONG></EM></SPAN></P></BODY></HTML> Mon, 28 May 2018 15:03:54 GMT https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21107#M771522 shiveshsingh 2018-05-28T15:03:54Z Re: Issue with aggr function and dimension https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21108#M771523 <HTML><HEAD></HEAD><BODY><P>Sorry. I did not phrase it correctly.</P><P></P><P>When adding 2nd dimension, the numbers change which i want to prevent from happening. Anyway i can acheive this</P><P></P><P>Thanks</P></BODY></HTML> Mon, 28 May 2018 15:16:04 GMT https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21108#M771523 ramanarayan 2018-05-28T15:16:04Z Re: Issue with aggr function and dimension https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21109#M771524 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Aggr(NODISTINCT Count(DISTINCT Customer), Calc_FRCA_FR_Category)</STRONG></P></BODY></HTML> Mon, 28 May 2018 16:40:41 GMT https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21109#M771524 sunny_talwar 2018-05-28T16:40:41Z Re: Issue with aggr function and dimension https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21110#M771525 <HTML><HEAD></HEAD><BODY><P>Sorry Sunny. No luck <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Tue, 29 May 2018 06:26:05 GMT https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21110#M771525 ramanarayan 2018-05-29T06:26:05Z Re: Issue with aggr function and dimension https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21111#M771526 <HTML><HEAD></HEAD><BODY><P>Would you like to share sample?</P></BODY></HTML> Tue, 29 May 2018 07:59:59 GMT https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21111#M771526 Anil_Babu_Samineni 2018-05-29T07:59:59Z Re: Issue with aggr function and dimension https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21112#M771527 <HTML><HEAD></HEAD><BODY><P>Do you mean that you want to duplicate the original table four times? One for each Calc_FRCA_FR_Category?</P><P></P><P>If so, use a dummy as your dimension:</P><P>=ValueList('High','Medium','Low','Never Loggedin')</P></BODY></HTML> Tue, 29 May 2018 08:19:28 GMT https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21112#M771527 Janneke 2018-05-29T08:19:28Z Re: Issue with aggr function and dimension https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21113#M771528 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample?</P></BODY></HTML> Tue, 29 May 2018 11:00:04 GMT https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21113#M771528 sunny_talwar 2018-05-29T11:00:04Z Re: Issue with aggr function and dimension https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21114#M771529 <HTML><HEAD></HEAD><BODY><P>Hi Sunny/Anil,</P><P></P><P>Attached is the qvw and excel with sample data.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 29 May 2018 14:58:45 GMT https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21114#M771529 ramanarayan 2018-05-29T14:58:45Z Re: Issue with aggr function and dimension https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21115#M771530 <HTML><HEAD></HEAD><BODY><P>added above. Thanks Anil</P></BODY></HTML> Tue, 29 May 2018 14:59:09 GMT https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21115#M771530 ramanarayan 2018-05-29T14:59:09Z Re: Issue with aggr function and dimension https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21116#M771531 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>=Count(TOTAL &lt;FRCA_WeekYear&gt; Customer)</STRONG></P><P></P><P>Or this</P><P></P><P><STRONG>=Aggr(NODISTINCT Count(Customer), FRCA_WeekYear)</STRONG></P></BODY></HTML> Tue, 29 May 2018 15:02:31 GMT https://community.qlik.com/t5/QlikView/Issue-with-aggr-function-and-dimension/m-p/21116#M771531 sunny_talwar 2018-05-29T15:02:31Z