topic Re: Nedd Help in Chart in QlikView https://community.qlik.com/t5/QlikView/Nedd-Help-in-Chart/m-p/452156#M1158352 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can create an expression as </P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></SPAN></P><P>Sum</P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[no of call]</SPAN><SPAN style="font-size: 8pt;">)*</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #800000; font-size: 8pt;">[call Duration]</SPAN><SPAN style="font-size: 8pt;">)&nbsp; then you will get the total as 258</SPAN><P></P><P></P></BODY></HTML> Fri, 25 Jan 2013 10:31:07 GMT 2013-01-25T10:31:07Z Nedd Help in Chart https://community.qlik.com/t5/QlikView/Nedd-Help-in-Chart/m-p/452152#M1158348 <HTML><HEAD></HEAD><BODY><P>i have chart where i am showing the total call duration of user id</P><P></P><P>my total is coming as 258(total duration) and 15(no of call)</P><P></P><P>so i want that the first row of straight table that shoew the sum of below rows as 17.2 instead of 258 without changing the the below row</P><P></P><P>I am also attching the application file where i have mentioned my requirement</P></BODY></HTML> Thu, 24 Jan 2013 06:14:01 GMT https://community.qlik.com/t5/QlikView/Nedd-Help-in-Chart/m-p/452152#M1158348 2013-01-24T06:14:01Z Re: Nedd Help in Chart https://community.qlik.com/t5/QlikView/Nedd-Help-in-Chart/m-p/452153#M1158349 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Find the attched file</P></BODY></HTML> Thu, 24 Jan 2013 06:30:45 GMT https://community.qlik.com/t5/QlikView/Nedd-Help-in-Chart/m-p/452153#M1158349 kumarnatarajan 2013-01-24T06:30:45Z Re: Nedd Help in Chart https://community.qlik.com/t5/QlikView/Nedd-Help-in-Chart/m-p/452154#M1158350 <HTML><HEAD></HEAD><BODY><P>The solution that u have provided is hardcode, suppose tomarrow one new column is added then i have to change it again.</P></BODY></HTML> Thu, 24 Jan 2013 06:50:42 GMT https://community.qlik.com/t5/QlikView/Nedd-Help-in-Chart/m-p/452154#M1158350 2013-01-24T06:50:42Z Re: Nedd Help in Chart https://community.qlik.com/t5/QlikView/Nedd-Help-in-Chart/m-p/452155#M1158351 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please explain me in detail, How you are calculating that value</P></BODY></HTML> Thu, 24 Jan 2013 07:00:49 GMT https://community.qlik.com/t5/QlikView/Nedd-Help-in-Chart/m-p/452155#M1158351 kumarnatarajan 2013-01-24T07:00:49Z Re: Nedd Help in Chart https://community.qlik.com/t5/QlikView/Nedd-Help-in-Chart/m-p/452156#M1158352 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can create an expression as </P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></SPAN></P><P>Sum</P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[no of call]</SPAN><SPAN style="font-size: 8pt;">)*</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #800000; font-size: 8pt;">[call Duration]</SPAN><SPAN style="font-size: 8pt;">)&nbsp; then you will get the total as 258</SPAN><P></P><P></P></BODY></HTML> Fri, 25 Jan 2013 10:31:07 GMT https://community.qlik.com/t5/QlikView/Nedd-Help-in-Chart/m-p/452156#M1158352 2013-01-25T10:31:07Z