topic Re: show numbers in % in QlikView https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124523#M898768 <HTML><HEAD></HEAD><BODY><P>I am exporting the data from excel and it is shown in % in excel as well. In expression, i am just using the column names</P></BODY></HTML> Fri, 22 Jul 2016 10:51:04 GMT vireshkolagimat 2016-07-22T10:51:04Z show numbers in % https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124521#M898766 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have data in the below format. when i try to show the change column in %, i not getting the expected result.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 4</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">56%</TD><TD style="padding: 2px;">60%</TD><TD style="padding: 2px;">(4%)</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">55%</TD><TD style="padding: 2px;">56%</TD><TD style="padding: 2px;">(1%)</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">33%</TD><TD style="padding: 2px;">32%</TD><TD style="padding: 2px;">1%</TD></TR></TBODY></TABLE><P></P><P>the result should be the one shown i the table but i am getting 0% for both 2nd and 3rd row. how to fix this. I need to show the difference of 2nd and 3rd column in %.</P><P></P><P>Regards,</P><P>Viresh</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124521#M898766 vireshkolagimat 2020-11-25T16:16:04Z Re: show numbers in % https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124522#M898767 <HTML><HEAD></HEAD><BODY><P>What is the expression used here? and what kind of formatting is used?</P></BODY></HTML> Fri, 22 Jul 2016 10:47:55 GMT https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124522#M898767 sunny_talwar 2016-07-22T10:47:55Z Re: show numbers in % https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124523#M898768 <HTML><HEAD></HEAD><BODY><P>I am exporting the data from excel and it is shown in % in excel as well. In expression, i am just using the column names</P></BODY></HTML> Fri, 22 Jul 2016 10:51:04 GMT https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124523#M898768 vireshkolagimat 2016-07-22T10:51:04Z Re: show numbers in % https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124524#M898769 <HTML><HEAD></HEAD><BODY><P>can you upload an example please? What you ask if far too vague!</P><P></P><P>Andy</P><P></P><P><A href="https://community.qlik.com/docs/DOC-7538">Qlik Community Tip: Posting Successful Discussion Threads</A></P></BODY></HTML> Fri, 22 Jul 2016 10:52:04 GMT https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124524#M898769 awhitfield 2016-07-22T10:52:04Z Re: show numbers in % https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124525#M898770 <HTML><HEAD></HEAD><BODY><P>I am still not sure what is going on. Would you be able to share a sample or screenshots?</P></BODY></HTML> Fri, 22 Jul 2016 10:56:00 GMT https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124525#M898770 sunny_talwar 2016-07-22T10:56:00Z Re: show numbers in % https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124526#M898771 <HTML><HEAD></HEAD><BODY><P>Viresh, Try to put expression is Relative and they Go to Number tab and then Choose that expression Integer and Check the %</P><P></P><P>Or If you have calc expressions please share sample App</P></BODY></HTML> Fri, 22 Jul 2016 11:22:40 GMT https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124526#M898771 Anil_Babu_Samineni 2016-07-22T11:22:40Z Re: show numbers in % https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124527#M898772 <HTML><HEAD></HEAD><BODY><P>Hey, i tried it but getting different numbers. attached is the sample data and qvw.</P><P>Thanks</P></BODY></HTML> Sat, 23 Jul 2016 18:03:35 GMT https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124527#M898772 vireshkolagimat 2016-07-23T18:03:35Z Re: show numbers in % https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124528#M898773 <HTML><HEAD></HEAD><BODY><P>Viresh, in the number tab select the "Change" field and set it to Fixed- 1 decimals.&nbsp; See screenshot.<IMG alt="cOMMUNITY-226148.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/132285_cOMMUNITY-226148.png" style="height: 344px; width: 620px;" /></P><P></P><P></P><P>Regards,</P><P>Carlos</P></BODY></HTML> Sat, 23 Jul 2016 18:23:26 GMT https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124528#M898773 clondono 2016-07-23T18:23:26Z Re: show numbers in % https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124529#M898774 <HTML><HEAD></HEAD><BODY><P>Hi Carlos,</P><P></P><P>Thanks but i don't want show the decimal places .</P><P>When i try to show the negative numbers in brackets still getting 0.0% even after providing single decimal place.</P><P></P><P>Regards,</P><P>Vires</P></BODY></HTML> Sun, 24 Jul 2016 17:28:29 GMT https://community.qlik.com/t5/QlikView/show-numbers-in/m-p/1124529#M898774 vireshkolagimat 2016-07-24T17:28:29Z