Documents for QlikView related information.
Dates (like the LastUsed date) in the CalData.pgo.xml file are saved as 64 bit hexadecimal numbers.
Those numbers can be converted to decimals by using the double precision floating point format (IEEE-754 standard).
And if you have a decimal number, you can format the number as a date.
I wrote a very powerful formula for this type of conversion.
You can use this formula anywhere in your QlikView document, because it is just some code in a variable.
Just add a new variable with the name eConvertHexToDec and paste in the formula from the attached text file.
After adding the formula to your document, you can use it like any other variable.
One thing, you must use dollar sign expansion.
So, this is the right way: $(eConvertHexToDec(LastUsed))
If you want to test it with the Pi number in a textbox, you must enter this in the text field:
And the result should be 3.1415926535898.
For an example look at the attached QlikView document.
One more thing, the hexadecimal number must always be 16 characters long.
Have fun with it.
Thank you very much Rene.
Thank you very much. The code worked like a charm!
Articles like this are the reason I love the community. This multi-lines long formula is also required to interpret many number values in the XML project structure. I've made a nice bookmark report out of this, which reports all bookmark settings (including Fields and values).
i am having some troubles working with this variable maybe i am missing something.
i have created a new variable called Convert64bit_HEXtoDEC and pasted the code Convert64bit_HEXtoDEC .txt in it, but it is generating errors with bad field names $1.
appreciate your help.
The same thing happened to me when I put the code in a variable. I do not know why this happens, but the variable should work when using it.
How do you use the variable? It works for me. The parameter needs to be a text..
can someone please attach a sample working qvw with the variable and a working text object?
Cannot attached a document here. But I've tried at least the Pi example which worked in v11.2 SR5:
Here is a example: License_Analyser_K3FDS.qvw