topic Using hex value in load script in QlikView

Using hex value in load script

Mon, 16 Apr 2012 20:47:49 GMT

I want to use this where clause in a script when loading data from a SQL table

WHERE Create_Date > '2012-01-01' AND ID = '0000000000001D5E';

I've checked the hex value in the table and its oorrect but this statement doesn't return any values.

I've created a list box and displayed the ID field and I can filter on this value and I also copied the cell value to paste in to the above statement.

Any ideas why this fails to return any records...the date bit works correctly on its own

Using hex value in load script

rwunderlich — Tue, 17 Apr 2012 03:21:40 GMT

To use a hex value, you must preceed it with "0x" (assuming MS SQLServer). For example:

ID=0x0000000000001D5E

No quotes around the value.

-Rob

http://robwunderlich.com

Using hex value in load script

Tue, 17 Apr 2012 08:59:45 GMT

Thanks Rob...that solved it.