topic Re: Problem with sum of a calculated dimension in QlikView https://community.qlik.com/t5/QlikView/Problem-with-sum-of-a-calculated-dimension/m-p/624090#M229676 <HTML><HEAD></HEAD><BODY><P>Anybody able to help? </P><P></P><P>Meanwhile I assume it is standard behavior, but it would be nice if someone could either confirm or guide me to an alternative solution.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 19 Mar 2014 07:46:24 GMT 2014-03-19T07:46:24Z Problem with sum of a calculated dimension https://community.qlik.com/t5/QlikView/Problem-with-sum-of-a-calculated-dimension/m-p/624085#M229671 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a straight table with several dimensions and expression. Three expressions are calculating monetary values and it is requested that totals for these are shown. Problem is, that when you click on a single sum from one of these expressions, all dimension values are selected, but not the value of the expression itself. </P><P></P><P>I then changed the three expressions to be calculated dimensions and this is working fine, I can now select a specific value by clicking. But, as these fields are now calculated dimensions, I cannot show a total number anymore.</P><P></P><P>Any ideas?</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 11 Mar 2014 12:34:18 GMT https://community.qlik.com/t5/QlikView/Problem-with-sum-of-a-calculated-dimension/m-p/624085#M229671 2014-03-11T12:34:18Z Re: Problem with sum of a calculated dimension https://community.qlik.com/t5/QlikView/Problem-with-sum-of-a-calculated-dimension/m-p/624086#M229672 <HTML><HEAD></HEAD><BODY><P>Can you load your sample file or apps?</P></BODY></HTML> Tue, 11 Mar 2014 12:35:20 GMT https://community.qlik.com/t5/QlikView/Problem-with-sum-of-a-calculated-dimension/m-p/624086#M229672 MK_QSL 2014-03-11T12:35:20Z Re: Problem with sum of a calculated dimension https://community.qlik.com/t5/QlikView/Problem-with-sum-of-a-calculated-dimension/m-p/624087#M229673 <HTML><HEAD></HEAD><BODY><P>That's a bit difficult, but I'll prepare one.</P></BODY></HTML> Tue, 11 Mar 2014 12:54:48 GMT https://community.qlik.com/t5/QlikView/Problem-with-sum-of-a-calculated-dimension/m-p/624087#M229673 2014-03-11T12:54:48Z Re: Problem with sum of a calculated dimension https://community.qlik.com/t5/QlikView/Problem-with-sum-of-a-calculated-dimension/m-p/624088#M229674 <HTML><HEAD></HEAD><BODY><P>Did you consider doing your calculations in the load script? </P></BODY></HTML> Tue, 11 Mar 2014 12:57:45 GMT https://community.qlik.com/t5/QlikView/Problem-with-sum-of-a-calculated-dimension/m-p/624088#M229674 2014-03-11T12:57:45Z Re: Re: Problem with sum of a calculated dimension https://community.qlik.com/t5/QlikView/Problem-with-sum-of-a-calculated-dimension/m-p/624089#M229675 <HTML><HEAD></HEAD><BODY><P>Here's my sample app. That is the original version where TCVs and IYR are expressions and you cannot select a single value (e.g. if you select '4€' in the 'TCV gewichtet' field, it select all other fields from that line and shows only one row, I would expect to see both rows with '4€' values.</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 17 Mar 2014 09:18:07 GMT https://community.qlik.com/t5/QlikView/Problem-with-sum-of-a-calculated-dimension/m-p/624089#M229675 2014-03-17T09:18:07Z Re: Problem with sum of a calculated dimension https://community.qlik.com/t5/QlikView/Problem-with-sum-of-a-calculated-dimension/m-p/624090#M229676 <HTML><HEAD></HEAD><BODY><P>Anybody able to help? </P><P></P><P>Meanwhile I assume it is standard behavior, but it would be nice if someone could either confirm or guide me to an alternative solution.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 19 Mar 2014 07:46:24 GMT https://community.qlik.com/t5/QlikView/Problem-with-sum-of-a-calculated-dimension/m-p/624090#M229676 2014-03-19T07:46:24Z