topic Re: Display cummulative value in QlikView https://community.qlik.com/t5/QlikView/Display-cummulative-value/m-p/692988#M474253 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Thu, 25 Sep 2014 10:45:55 GMT sundarakumar 2014-09-25T10:45:55Z Display cummulative value https://community.qlik.com/t5/QlikView/Display-cummulative-value/m-p/692987#M474252 <HTML><HEAD></HEAD><BODY><P><BR />Hi Everyone,</P><P></P><P> I would like to display the sum of all values upto current month in data points upon mouse over. For example, if i have a chart with month names in dimension and some value being used in expression, if i hover over the May month's value, it should show the sum of all values starting from Jan to May in tool tip( as data points). Is it possible?</P><P></P><P>Please advice.</P><P></P><P>Thanks,</P><P>Senthil.</P></BODY></HTML> Thu, 25 Sep 2014 10:31:53 GMT https://community.qlik.com/t5/QlikView/Display-cummulative-value/m-p/692987#M474252 2014-09-25T10:31:53Z Re: Display cummulative value https://community.qlik.com/t5/QlikView/Display-cummulative-value/m-p/692988#M474253 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Thu, 25 Sep 2014 10:45:55 GMT https://community.qlik.com/t5/QlikView/Display-cummulative-value/m-p/692988#M474253 sundarakumar 2014-09-25T10:45:55Z Re: Re: Display cummulative value https://community.qlik.com/t5/QlikView/Display-cummulative-value/m-p/692989#M474254 <HTML><HEAD></HEAD><BODY><P>U&nbsp; can have it as a different field for pop up, or u can use dual for the same purpose, like in the attachment.</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">dual</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;">stock</SPAN><SPAN style="font-size: 8pt;">)&amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">chr</SPAN><SPAN style="font-size: 8pt;">(10)&amp;'Accumulated = '&amp;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">rangesum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">above</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;">stock</SPAN><SPAN style="font-size: 8pt;">),0,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">rowno</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;">stock</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P></P></BODY></HTML> Thu, 25 Sep 2014 10:50:50 GMT https://community.qlik.com/t5/QlikView/Display-cummulative-value/m-p/692989#M474254 sundarakumar 2014-09-25T10:50:50Z Re: Display cummulative value https://community.qlik.com/t5/QlikView/Display-cummulative-value/m-p/692990#M474255 <HTML><HEAD></HEAD><BODY><P>Hey Sundarakumar,</P><P></P><P>Thank you for your quick response. It seems to be working great <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 25 Sep 2014 11:07:44 GMT https://community.qlik.com/t5/QlikView/Display-cummulative-value/m-p/692990#M474255 2014-09-25T11:07:44Z