topic Re: Calculation inside of a diagramm / chart in QlikView https://community.qlik.com/t5/QlikView/Calculation-inside-of-a-diagramm-chart/m-p/439310#M564384 <HTML><HEAD></HEAD><BODY><P>and sum(if worked </P><P></P><P>Thx a lot</P></BODY></HTML> Mon, 21 Jan 2013 16:20:15 GMT Anonymous 2013-01-21T16:20:15Z Calculation inside of a diagramm / chart https://community.qlik.com/t5/QlikView/Calculation-inside-of-a-diagramm-chart/m-p/439304#M564378 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the following problem:</P><P></P><P>I have a Table with different states and time linked to this state</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>State</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Duration</STRONG></SPAN></TH></TR><TR><TD>State_1</TD><TD>1</TD></TR><TR><TD>State_2</TD><TD>1.5</TD></TR><TR><TD>State_3</TD><TD>45</TD></TR><TR><TD>State_3</TD><TD>2</TD></TR></TBODY></TABLE><P></P><P>What I did was putting the State as dimension and sum(Duration) as formula.</P><P>The problem now is , that I have to split the State_3 in 3 other substates. </P><P></P><P>I tried the following: I put the State our of dimentions and added every State as formula </P><P>(If(State=State_1;sum(duration);0)</P><P>and called the formula State_1.</P><P></P><P>Unfortunatly QlikView is showing me always 0 as the result..</P><P></P><P>Any idea?</P><P></P><P>Cheers chesterluck</P></BODY></HTML> Mon, 21 Jan 2013 13:44:37 GMT https://community.qlik.com/t5/QlikView/Calculation-inside-of-a-diagramm-chart/m-p/439304#M564378 Anonymous 2013-01-21T13:44:37Z Re: Calculation inside of a diagramm / chart https://community.qlik.com/t5/QlikView/Calculation-inside-of-a-diagramm-chart/m-p/439305#M564379 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>why don't you add another subdimension as State_3_1, State_3_2...</P><P>You can then display States 1, 2, 3 as total or see split states if you develop your graph</P><P></P><P>Christian</P></BODY></HTML> Mon, 21 Jan 2013 13:48:18 GMT https://community.qlik.com/t5/QlikView/Calculation-inside-of-a-diagramm-chart/m-p/439305#M564379 2013-01-21T13:48:18Z Re: Calculation inside of a diagramm / chart https://community.qlik.com/t5/QlikView/Calculation-inside-of-a-diagramm-chart/m-p/439306#M564380 <HTML><HEAD></HEAD><BODY><P>QV uses commas instead of semicolons in if statements.</P><P>Also, if you have an expression with if(&lt;test&gt;,sum(&lt;value&gt;)) then the test is carried out across all the rows, not for each value in the field. Try instead sum(if(&lt;test&gt;,&lt;value&gt;)) to do a test at a record by record level.</P><P>Jonathan</P></BODY></HTML> Mon, 21 Jan 2013 13:53:08 GMT https://community.qlik.com/t5/QlikView/Calculation-inside-of-a-diagramm-chart/m-p/439306#M564380 Anonymous 2013-01-21T13:53:08Z Re: Calculation inside of a diagramm / chart https://community.qlik.com/t5/QlikView/Calculation-inside-of-a-diagramm-chart/m-p/439307#M564381 <HTML><HEAD></HEAD><BODY><P>@Jonathan: I used of course commas in the formula - otherwise it wouls show a syntax error..</P><P>@Christion: I can surely do it in the loading process (probably I will), but I thought that such things can also be done in the chart itself...</P><P></P><P></P><P>Cheers chesterluck</P></BODY></HTML> Mon, 21 Jan 2013 14:31:22 GMT https://community.qlik.com/t5/QlikView/Calculation-inside-of-a-diagramm-chart/m-p/439307#M564381 Anonymous 2013-01-21T14:31:22Z Re: Calculation inside of a diagramm / chart https://community.qlik.com/t5/QlikView/Calculation-inside-of-a-diagramm-chart/m-p/439308#M564382 <HTML><HEAD></HEAD><BODY><P>@Jonathan: I used of course commas in the formula - otherwise it wouls show a syntax error..</P><P>@Christion: I can surely do it in the loading process (probably I will), but I thought that such things can also be done in the chart itself...</P><P></P><P></P><P>Cheers chesterluck</P></BODY></HTML> Mon, 21 Jan 2013 14:31:28 GMT https://community.qlik.com/t5/QlikView/Calculation-inside-of-a-diagramm-chart/m-p/439308#M564382 Anonymous 2013-01-21T14:31:28Z Re: Calculation inside of a diagramm / chart https://community.qlik.com/t5/QlikView/Calculation-inside-of-a-diagramm-chart/m-p/439309#M564383 <HTML><HEAD></HEAD><BODY><P>How about the second point about the sum(if... vs. if(sum... ordering ? Does that help.</P><P>Jonathan</P></BODY></HTML> Mon, 21 Jan 2013 14:43:17 GMT https://community.qlik.com/t5/QlikView/Calculation-inside-of-a-diagramm-chart/m-p/439309#M564383 Anonymous 2013-01-21T14:43:17Z Re: Calculation inside of a diagramm / chart https://community.qlik.com/t5/QlikView/Calculation-inside-of-a-diagramm-chart/m-p/439310#M564384 <HTML><HEAD></HEAD><BODY><P>and sum(if worked </P><P></P><P>Thx a lot</P></BODY></HTML> Mon, 21 Jan 2013 16:20:15 GMT https://community.qlik.com/t5/QlikView/Calculation-inside-of-a-diagramm-chart/m-p/439310#M564384 Anonymous 2013-01-21T16:20:15Z