topic text method for field values in QlikView https://community.qlik.com/t5/QlikView/text-method-for-field-values/m-p/220495#M73404 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>I'm trying to write macros which works with bookmarks and got this problem: I'm using API to export all selected fields values to .txt file. I'm using this method:</P><P><STRONG></STRONG></P><P>set bmm = ActiveDocument.GetBookmark("BM02") 'getting Bookmark object</P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold">set</P><B></B><P style="font-weight: bold"></P>flditems=bmm.Bookmark.FieldItems 'getting active fields for Bookmark <BR /><BR /> <P></P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold">set</P><B></B><P style="font-weight: bold"></P>BMFldValues = flditems.Item(i).Values 'getting selected values for field "Item(i)" for example it's DATE field <BR /><BR /> <P></P><P></P><P>txsStream.Write BMFldValues.Item(j).number 'and I'm writing one of actual selected values in the DATE field to the file</P><P></P><P></P><P></P><BR /><BR /> <P></P><P>BUT... in this way instead of date I got something like '36519' in my file instead of 25.12.1999, which is normal reaction for .number method. So, I'm trying to use method txsStream.Write BMFldValues.Item(j).text ... and here I got nothing, just an empty string in my file and in debug expression window.</P><P>So, how can I get text representation of numerical fields in API???</P><P>Thanks for help.</P></BODY></HTML> Tue, 28 Sep 2010 11:37:48 GMT 2010-09-28T11:37:48Z text method for field values https://community.qlik.com/t5/QlikView/text-method-for-field-values/m-p/220495#M73404 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>I'm trying to write macros which works with bookmarks and got this problem: I'm using API to export all selected fields values to .txt file. I'm using this method:</P><P><STRONG></STRONG></P><P>set bmm = ActiveDocument.GetBookmark("BM02") 'getting Bookmark object</P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold">set</P><B></B><P style="font-weight: bold"></P>flditems=bmm.Bookmark.FieldItems 'getting active fields for Bookmark <BR /><BR /> <P></P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold">set</P><B></B><P style="font-weight: bold"></P>BMFldValues = flditems.Item(i).Values 'getting selected values for field "Item(i)" for example it's DATE field <BR /><BR /> <P></P><P></P><P>txsStream.Write BMFldValues.Item(j).number 'and I'm writing one of actual selected values in the DATE field to the file</P><P></P><P></P><P></P><BR /><BR /> <P></P><P>BUT... in this way instead of date I got something like '36519' in my file instead of 25.12.1999, which is normal reaction for .number method. So, I'm trying to use method txsStream.Write BMFldValues.Item(j).text ... and here I got nothing, just an empty string in my file and in debug expression window.</P><P>So, how can I get text representation of numerical fields in API???</P><P>Thanks for help.</P></BODY></HTML> Tue, 28 Sep 2010 11:37:48 GMT https://community.qlik.com/t5/QlikView/text-method-for-field-values/m-p/220495#M73404 2010-09-28T11:37:48Z Re. :text method for field values https://community.qlik.com/t5/QlikView/text-method-for-field-values/m-p/220496#M73405 <HTML><HEAD></HEAD><BODY><P>Hi, have you looked to get date representation of numerical fields ?</P></BODY></HTML> Tue, 28 Sep 2010 14:23:39 GMT https://community.qlik.com/t5/QlikView/text-method-for-field-values/m-p/220496#M73405 martin59 2010-09-28T14:23:39Z Re. :text method for field values https://community.qlik.com/t5/QlikView/text-method-for-field-values/m-p/220497#M73406 <HTML><HEAD></HEAD><BODY><P>Hi, Martin. Thanks a lot for answer.</P><P>No, I didnt see any "get date representation", dont even know what it is.</P><P>Can you tell me what is it or at least where I can find some info about this "get date representation"?</P></BODY></HTML> Tue, 28 Sep 2010 14:52:09 GMT https://community.qlik.com/t5/QlikView/text-method-for-field-values/m-p/220497#M73406 2010-09-28T14:52:09Z