topic Re: Number format in QlikView https://community.qlik.com/t5/QlikView/Number-format/m-p/1443157#M432803 <HTML><HEAD></HEAD><BODY><P>Any other help ? <A href="https://community.qlik.com/qlik-users/15823">swuehl</A>‌ <A href="https://community.qlik.com/qlik-users/26418">tresesco</A>‌</P></BODY></HTML> Thu, 23 Nov 2017 11:11:42 GMT yogitamehta10 2017-11-23T11:11:42Z Number format https://community.qlik.com/t5/QlikView/Number-format/m-p/1443153#M432799 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; HI ALL,</SPAN></P><P></P><P><SPAN style="color: #000000;"><SPAN style="font-family: Calibri; font-size: 12pt;">I have in my dashboard all the values are coming in</SPAN><SPAN style="font-family: 'Segoe UI',sans-serif; font-size: 10pt; mso-style-textoutline-type: solid; mso-style-textoutline-fill-color: black; mso-style-textoutline-fill-alpha: 100.0%; mso-style-textoutline-outlinestyle-dpiwidth: .75pt; mso-style-textoutline-outlinestyle-linecap: flat; mso-style-textoutline-outlinestyle-join: round; mso-style-textoutline-outlinestyle-pctmiterlimit: 0%; mso-style-textoutline-outlinestyle-dash: solid; mso-style-textoutline-outlinestyle-align: center; mso-style-textoutline-outlinestyle-compound: simple; mso-style-textfill-type: none; mso-style-textfill-fill-gradientfill-shadetype: linear; mso-style-textfill-fill-gradientfill-shade-linearshade-angle: 0; mso-style-textfill-fill-gradientfill-shade-linearshade-fscaled: no;">712239181.798289</SPAN></SPAN><SPAN style="color: black; font-family: 'Segoe UI',sans-serif; font-size: 10pt;">&nbsp; bot users want to show in&nbsp; dashboard in thousand like this&nbsp; </SPAN><SPAN lang="EN-US" style="color: black; font-family: 'Segoe UI',sans-serif; font-size: 10pt; mso-ansi-language: EN-US;">712,239 and when we export the data it should&nbsp; come original value </SPAN><SPAN style="color: #000000;"><SPAN style="font-family: Calibri; font-size: 12pt;">in</SPAN><SPAN style="font-family: 'Segoe UI',sans-serif; font-size: 10pt; mso-style-textoutline-type: solid; mso-style-textoutline-fill-color: black; mso-style-textoutline-fill-alpha: 100.0%; mso-style-textoutline-outlinestyle-dpiwidth: .75pt; mso-style-textoutline-outlinestyle-linecap: flat; mso-style-textoutline-outlinestyle-join: round; mso-style-textoutline-outlinestyle-pctmiterlimit: 0%; mso-style-textoutline-outlinestyle-dash: solid; mso-style-textoutline-outlinestyle-align: center; mso-style-textoutline-outlinestyle-compound: simple; mso-style-textfill-type: none; mso-style-textfill-fill-gradientfill-shadetype: linear; mso-style-textfill-fill-gradientfill-shade-linearshade-angle: 0; mso-style-textfill-fill-gradientfill-shade-linearshade-fscaled: no;">712239181.798289</SPAN></SPAN><SPAN style="color: black; font-family: 'Segoe UI',sans-serif; font-size: 10pt;">&nbsp;&nbsp; ,..Please help. I’m using this number format&nbsp; .’</SPAN><SPAN style="color: black; font-family: 'Arial',sans-serif; font-size: 9pt;"> #,##0 ‘.</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">TIA!</SPAN></P></BODY></HTML> Wed, 22 Nov 2017 16:19:30 GMT https://community.qlik.com/t5/QlikView/Number-format/m-p/1443153#M432799 yogitamehta10 2017-11-22T16:19:30Z Re: Number format https://community.qlik.com/t5/QlikView/Number-format/m-p/1443154#M432800 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>Num(KeepChar(Field,'0123456789.')/1000,'#,##0 K')</P><P>K is optional</P></BODY></HTML> Wed, 22 Nov 2017 16:36:54 GMT https://community.qlik.com/t5/QlikView/Number-format/m-p/1443154#M432800 antoniotiman 2017-11-22T16:36:54Z Re: Number format https://community.qlik.com/t5/QlikView/Number-format/m-p/1443155#M432801 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><IMG alt="num11.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/184255_num11.png" style="height: auto;" /></P></BODY></HTML> Wed, 22 Nov 2017 17:14:06 GMT https://community.qlik.com/t5/QlikView/Number-format/m-p/1443155#M432801 el_aprendiz111 2017-11-22T17:14:06Z Re: Number format https://community.qlik.com/t5/QlikView/Number-format/m-p/1443156#M432802 <HTML><HEAD></HEAD><BODY><P>But I cant&nbsp; export in the original&nbsp; format then</P></BODY></HTML> Thu, 23 Nov 2017 11:01:44 GMT https://community.qlik.com/t5/QlikView/Number-format/m-p/1443156#M432802 yogitamehta10 2017-11-23T11:01:44Z Re: Number format https://community.qlik.com/t5/QlikView/Number-format/m-p/1443157#M432803 <HTML><HEAD></HEAD><BODY><P>Any other help ? <A href="https://community.qlik.com/qlik-users/15823">swuehl</A>‌ <A href="https://community.qlik.com/qlik-users/26418">tresesco</A>‌</P></BODY></HTML> Thu, 23 Nov 2017 11:11:42 GMT https://community.qlik.com/t5/QlikView/Number-format/m-p/1443157#M432803 yogitamehta10 2017-11-23T11:11:42Z Re: Number format https://community.qlik.com/t5/QlikView/Number-format/m-p/1443158#M432804 <HTML><HEAD></HEAD><BODY><P>Hi Yogita</P><P></P><P>with a macro </P><P></P><P><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: #4472c4;">sub sendXls</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /> </SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: #4472c4;">SET </SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">CHART = ActiveDocument.</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: #4472c4;">GetSheetObject</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">("CH11")<BR /> </SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: #4472c4;">SET </SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">X = Chart.</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: #4472c4;">GetProperties</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /> Chart.SendToExcel<BR /> </SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: #4472c4;">SET CHART</SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">=NOTHING<BR /> </SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: #4472c4;">SET </SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">X = NOTHING<BR /> </SPAN><SPAN lang="EN-US" style="font-size: 9.0pt; font-family: 'Courier New'; color: #4472c4;">end sub </SPAN></P></BODY></HTML> Thu, 23 Nov 2017 16:15:09 GMT https://community.qlik.com/t5/QlikView/Number-format/m-p/1443158#M432804 el_aprendiz111 2017-11-23T16:15:09Z