topic Number & % in QlikView https://community.qlik.com/t5/QlikView/Number/m-p/1343660#M830134 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P>I have created dashboard which has multiple charts dependent on formulas. Now suddenly requirements get change.</P><P>Now we want button which shows data in Number &amp; % on click.</P><P>I have Product dimension &amp; following formula in expression:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Handled_By</SPAN><SPAN style="font-size: 8pt;">={E1},</SPAN><SPAN style="color: #800000; font-size: 8pt;">Task</SPAN><SPAN style="font-size: 8pt;">={'T1','T2','T3'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Efforts_Hrs</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167789_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P></P><P><SPAN style="font-size: 8pt;">I want to show this chart in number and % also on click. What formula should I write to convert this in %. I tried "Relative" option but it does not fulfilling my requirements.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">do we have any short way to do this changes in whole dashboard? thanks in adv</SPAN></P><P></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Number & % https://community.qlik.com/t5/QlikView/Number/m-p/1343660#M830134 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P>I have created dashboard which has multiple charts dependent on formulas. Now suddenly requirements get change.</P><P>Now we want button which shows data in Number &amp; % on click.</P><P>I have Product dimension &amp; following formula in expression:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Handled_By</SPAN><SPAN style="font-size: 8pt;">={E1},</SPAN><SPAN style="color: #800000; font-size: 8pt;">Task</SPAN><SPAN style="font-size: 8pt;">={'T1','T2','T3'}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Efforts_Hrs</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167789_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P></P><P><SPAN style="font-size: 8pt;">I want to show this chart in number and % also on click. What formula should I write to convert this in %. I tried "Relative" option but it does not fulfilling my requirements.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">do we have any short way to do this changes in whole dashboard? thanks in adv</SPAN></P><P></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Number/m-p/1343660#M830134 2020-11-25T16:16:04Z Re: Number & % https://community.qlik.com/t5/QlikView/Number/m-p/1343661#M830135 <HTML><HEAD></HEAD><BODY><P>If I understand your requirement correctly, I would address this by creating a second expression in the chart that shows the results in %, then make both expressions conditional.&nbsp; Then you can create a variable that is toggled by a button and insert that variable into the condition for the expression. </P><P>See Attached !</P></BODY></HTML> Thu, 22 Jun 2017 14:26:39 GMT https://community.qlik.com/t5/QlikView/Number/m-p/1343661#M830135 2017-06-22T14:26:39Z