topic Re: % in QlikView https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1379675#M817411 <HTML><HEAD></HEAD><BODY><P>Try to add expression with number of sales. Uncheck "bar" and check "text as popup" in properties.</P></BODY></HTML> Thu, 24 Aug 2017 13:26:05 GMT sergio0592 2017-08-24T13:26:05Z % https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1379674#M817410 <HTML><HEAD></HEAD><BODY><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/174535_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Hello! I need help!</P><P>I want to see number of sales when I put my arrow on segment. Instead of&nbsp;&nbsp;&nbsp;&nbsp; "ТОЧКИ=22.00%" I want to see&nbsp;&nbsp; "ТОЧКИ=number of sales by this year"&nbsp; and also I want to see like in my screen percentage above each segment. My expression is :</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;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">RowNo</SPAN><SPAN style="font-size: 8pt;">()=1, '',</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Num</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;">SUMI</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;">SUMRETURN</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;">SUMI</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;">SUMRETURN</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;">SUMI</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;">SUMRETURN</SPAN><SPAN style="font-size: 8pt;">)),'# ##0.00%')),</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">SUMI</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;">SUMRETURN</SPAN><SPAN style="font-size: 8pt;">)) ; How can I do this?</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Thanks!</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1379674#M817410 denis115 2020-11-25T16:16:04Z Re: % https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1379675#M817411 <HTML><HEAD></HEAD><BODY><P>Try to add expression with number of sales. Uncheck "bar" and check "text as popup" in properties.</P></BODY></HTML> Thu, 24 Aug 2017 13:26:05 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1379675#M817411 sergio0592 2017-08-24T13:26:05Z Re: % https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1379676#M817412 <HTML><HEAD></HEAD><BODY><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/174544_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 24 Aug 2017 13:33:51 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1379676#M817412 denis115 2017-08-24T13:33:51Z