Bookmark XML

[#1]

I want to be able to manipulate the XML file that you can export from the bookmark object.

I have a problem when I make bookmarks on the number field.
The number in the field in QlikView is not the same as the number in the tags <Number> in the XML file.

Is there a way to translate between the two different numbers?

Example: the tree numbers 1000232, 1000276, 1001483

translate to this in the XML file:

<FieldValue>

<Text></Text>

<IsNumeric>true</IsNumeric>

<Number>412E901600000000</Number>

</FieldValue>

<FieldValue>

<Text></Text>

<IsNumeric>true</IsNumeric>

<Number>412E865000000000</Number>

</FieldValue>

<FieldValue>

<Text></Text>

<IsNumeric>true</IsNumeric>

<Number>412E86A800000000</Number>

</FieldValue>

//johan

[#2]

Hi, did u find the answer to your question? I have the same problem now...

[#3]

Nope, no solution.

If you come up with anything, please post your solution or workaround.

[#4]

Hi, please let me know if you find the answer to your question ...

Francesca

[jcamps · Accepted solution]

Hi, fiddling with some examples and remembering my Maths, i managed to reverse engineer the values.

Is is just a hexadecimal conversion of a double number. See this web for example:

http://gregstoll.dyndns.org/~gregstoll/floattohex/

If you enter the XML value 412E901600000000 in the third box and click on "Convert to double" it will give you 1001483.0.

Cool eh?