topic Re: Straight Table shows '####' as value in QlikView https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339392#M821853 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Wed, 02 Aug 2017 14:44:55 GMT 2017-08-02T14:44:55Z Straight Table shows '####' as value https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339385#M821846 <HTML><HEAD></HEAD><BODY><P>I'm dividing two columns, and I think if the value is too small, it just shows ####. </P><P>Where can I change this?</P><P><IMG alt="change.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172233_change.png" style="height: 716px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339385#M821846 2020-11-25T16:16:04Z Re: Straight Table shows '####' as value https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339386#M821847 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Increase the width of the column.</P></BODY></HTML> Wed, 02 Aug 2017 14:29:02 GMT https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339386#M821847 ahaahaaha 2017-08-02T14:29:02Z Re: Straight Table shows '####' as value https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339387#M821848 <HTML><HEAD></HEAD><BODY><P>Hi Aaron,</P><P></P><P>You just have to format the column to show 2 decimal numbers, or to be a percentage.</P><P></P><P>Carlos</P></BODY></HTML> Wed, 02 Aug 2017 14:31:30 GMT https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339387#M821848 CarlosAMonroy 2017-08-02T14:31:30Z Re: Straight Table shows '####' as value https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339388#M821849 <HTML><HEAD></HEAD><BODY><P>Change the settings in the Number tab to two or 3 decimals. </P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172244_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 02 Aug 2017 14:32:41 GMT https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339388#M821849 vishsaggi 2017-08-02T14:32:41Z Re: Straight Table shows '####' as value https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339389#M821850 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Two options.</P><P>1. Increase the Width of the columns</P><P>2. Format the number using NUM() or in Number Tab</P></BODY></HTML> Wed, 02 Aug 2017 14:37:01 GMT https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339389#M821850 krishnacbe 2017-08-02T14:37:01Z Re: Straight Table shows '####' as value https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339390#M821851 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Wed, 02 Aug 2017 14:44:38 GMT https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339390#M821851 2017-08-02T14:44:38Z Re: Straight Table shows '####' as value https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339391#M821852 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Wed, 02 Aug 2017 14:44:47 GMT https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339391#M821852 2017-08-02T14:44:47Z Re: Straight Table shows '####' as value https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339392#M821853 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Wed, 02 Aug 2017 14:44:55 GMT https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339392#M821853 2017-08-02T14:44:55Z Re: Straight Table shows '####' as value https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339393#M821854 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Wed, 02 Aug 2017 14:45:05 GMT https://community.qlik.com/t5/QlikView/Straight-Table-shows-as-value/m-p/1339393#M821854 2017-08-02T14:45:05Z