topic Re: Amount in proper format in QlikView https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185988#M886172 <HTML><HEAD></HEAD><BODY><P>I am not sure whether I understand your issue. Would you describe more</P></BODY></HTML> Thu, 15 Sep 2016 13:44:12 GMT Anil_Babu_Samineni 2016-09-15T13:44:12Z Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185986#M886170 <HTML><HEAD></HEAD><BODY><P>i want to dislay total amount in proper format in table pls help</P><P></P><P>143294587.76802</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185986#M886170 vinod2086 2020-11-25T16:16:04Z Re: Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185987#M886171 <HTML><HEAD></HEAD><BODY><P>Have you tried changing the settings on the number's tab of chart properties? What is the proper format you are looking to get?</P></BODY></HTML> Thu, 15 Sep 2016 13:43:48 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185987#M886171 sunny_talwar 2016-09-15T13:43:48Z Re: Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185988#M886172 <HTML><HEAD></HEAD><BODY><P>I am not sure whether I understand your issue. Would you describe more</P></BODY></HTML> Thu, 15 Sep 2016 13:44:12 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185988#M886172 Anil_Babu_Samineni 2016-09-15T13:44:12Z Re: Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185989#M886173 <HTML><HEAD></HEAD><BODY><P>i had tried but option is not enabling</P><P>u mean number tab only ryt</P></BODY></HTML> Thu, 15 Sep 2016 13:46:40 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185989#M886173 vinod2086 2016-09-15T13:46:40Z Re: Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185990#M886174 <HTML><HEAD></HEAD><BODY><P>it is displaying larger number ryt so want to display with out decimals</P></BODY></HTML> Thu, 15 Sep 2016 13:47:36 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185990#M886174 vinod2086 2016-09-15T13:47:36Z Re: Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185991#M886175 <HTML><HEAD></HEAD><BODY><P>Yes the numbers tab. What happens when you change the format on the numbers tab?</P></BODY></HTML> Thu, 15 Sep 2016 13:50:09 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185991#M886175 sunny_talwar 2016-09-15T13:50:09Z Re: Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185992#M886176 <HTML><HEAD></HEAD><BODY><P>Selecting 'Integer' doesn't help?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/137588_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 15 Sep 2016 13:51:12 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185992#M886176 sunny_talwar 2016-09-15T13:51:12Z Re: Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185993#M886177 <HTML><HEAD></HEAD><BODY><P>Try to format in expression</P><P></P><P>num(Expression,'#,##0.00')</P></BODY></HTML> Thu, 15 Sep 2016 13:56:00 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185993#M886177 krishnacbe 2016-09-15T13:56:00Z Re: Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185994#M886178 <HTML><HEAD></HEAD><BODY><P>same thing i had tried but option is disabled</P></BODY></HTML> Thu, 15 Sep 2016 14:00:55 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185994#M886178 vinod2086 2016-09-15T14:00:55Z Re: Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185995#M886179 <HTML><HEAD></HEAD><BODY><P>Sunny is right 1st try on the Number format tab and if it doesn't work (although it should ) then try the Num() function.</P><P></P><P>Num( your_expression , '#####.0000')</P></BODY></HTML> Thu, 15 Sep 2016 14:01:53 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185995#M886179 neelamsaroha157 2016-09-15T14:01:53Z Re: Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185996#M886180 <HTML><HEAD></HEAD><BODY><P>Is your chart detached? Check on the General tab if Detached is checked?</P></BODY></HTML> Thu, 15 Sep 2016 14:03:11 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185996#M886180 sunny_talwar 2016-09-15T14:03:11Z Re: Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185997#M886181 <HTML><HEAD></HEAD><BODY><P>Hey there,</P><P></P><P>What is the proper format you what to make the number?</P><P></P><P>Regards,</P><P>MB</P></BODY></HTML> Thu, 15 Sep 2016 14:31:22 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185997#M886181 miguelbraga 2016-09-15T14:31:22Z Re: Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185998#M886182 <HTML><HEAD></HEAD><BODY><P>yes Braga</P></BODY></HTML> Thu, 15 Sep 2016 14:47:42 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185998#M886182 vinod2086 2016-09-15T14:47:42Z Re: Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185999#M886183 <HTML><HEAD></HEAD><BODY><P>Did you check if the chart was detached or not?</P></BODY></HTML> Thu, 15 Sep 2016 18:19:53 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1185999#M886183 sunny_talwar 2016-09-15T18:19:53Z Re: Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1186000#M886184 <HTML><HEAD></HEAD><BODY><P>No sunny its not detached .. any way my issue got cleared now thanks all </P></BODY></HTML> Fri, 16 Sep 2016 10:09:05 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1186000#M886184 vinod2086 2016-09-16T10:09:05Z Re: Amount in proper format https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1186001#M886185 <HTML><HEAD></HEAD><BODY><P>What was the issue? Would you be able to let us know?</P></BODY></HTML> Fri, 16 Sep 2016 10:25:25 GMT https://community.qlik.com/t5/QlikView/Amount-in-proper-format/m-p/1186001#M886185 sunny_talwar 2016-09-16T10:25:25Z