topic Removing decimals from pivot table dimensions? in QlikView https://community.qlik.com/t5/QlikView/Removing-decimals-from-pivot-table-dimensions/m-p/450021#M565823 <HTML><HEAD></HEAD><BODY><P>Hi There! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I'm really new to Qlikview and was hoping to find out how to remove the decimal places from my dimensions.&nbsp; I have tried under the number tab but it doesn't seem to work on the dimensions.</P><P></P><P>Any advice in the right direction would be appreciated.</P><P></P><P>Regards</P><P>Shaun</P></BODY></HTML> Wed, 19 Dec 2012 07:24:20 GMT 2012-12-19T07:24:20Z Removing decimals from pivot table dimensions? https://community.qlik.com/t5/QlikView/Removing-decimals-from-pivot-table-dimensions/m-p/450021#M565823 <HTML><HEAD></HEAD><BODY><P>Hi There! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I'm really new to Qlikview and was hoping to find out how to remove the decimal places from my dimensions.&nbsp; I have tried under the number tab but it doesn't seem to work on the dimensions.</P><P></P><P>Any advice in the right direction would be appreciated.</P><P></P><P>Regards</P><P>Shaun</P></BODY></HTML> Wed, 19 Dec 2012 07:24:20 GMT https://community.qlik.com/t5/QlikView/Removing-decimals-from-pivot-table-dimensions/m-p/450021#M565823 2012-12-19T07:24:20Z Re: Removing decimals from pivot table dimensions? https://community.qlik.com/t5/QlikView/Removing-decimals-from-pivot-table-dimensions/m-p/450022#M565824 <HTML><HEAD></HEAD><BODY><P>Select the Dimension and Edit</P><P>then Use <STRONG>Num(Dimension,'###')</STRONG></P></BODY></HTML> Wed, 19 Dec 2012 07:29:06 GMT https://community.qlik.com/t5/QlikView/Removing-decimals-from-pivot-table-dimensions/m-p/450022#M565824 sreenivas 2012-12-19T07:29:06Z Re: Removing decimals from pivot table dimensions? https://community.qlik.com/t5/QlikView/Removing-decimals-from-pivot-table-dimensions/m-p/450023#M565825 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Wed, 19 Dec 2012 07:34:14 GMT https://community.qlik.com/t5/QlikView/Removing-decimals-from-pivot-table-dimensions/m-p/450023#M565825 2012-12-19T07:34:14Z