Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
realpixel
Creator
Creator

Convert HEX value to IP address

Hello,

On my chart, I have a column "SourceIP" with Hexadecimal value, like "0A5C0158", if I convert manualy this value to decimal I obtain 10.92.1.88 now I want to know if there are a possibility to convert all value in my chart from HEX to IP address, someone have an idea?

10 Replies
MarcoWedel

Hi,

another solution could be:

QlikCommunity_Thread_212929_Pic1.JPG

tabIP:

LOAD *,

    Dual(Mod(HexNum>>24,256)&'.'&Mod(HexNum>>16,256)&'.'&Mod(HexNum>>8,256)&'.'&Mod(HexNum,256),HexNum) as IP;

LOAD *,

    Num#(HexTxt,'(HEX)') as HexNum

Inline [

HexTxt

0A5C0158

3F2CA86E

7F000001

];

hope this helps

regards

Marco