topic Creating table fields based on binary numbers in QlikView

Creating table fields based on binary numbers

dana — Sat, 16 Nov 2024 18:07:47 GMT

Hi People,

I would appreciate some guidance in achieving the following:

I would like to generate records with 4 fields, having 0 or 1, using a loop that will run for binary values 1 to 15.

For example,

Loop index 1, value: 1000

Loop index 9 , value: 1001

Loop index 15, value: 1111

Thanks in Advance!

Or — Wed, 09 Sep 2020 14:37:50 GMT

Use Num() or Num#() with the format set to '(bin)'. This will force Qlik to format or interpret numeric values as binary.

dana — Wed, 09 Sep 2020 14:55:18 GMT

Hi,

The expression you suggested is not giving me the binary format I need.

My loop will generate values from 1 to 15.

I need to represent them as binary numbers, in order to split them later to 4 fields.

Thanks..

marcus_sommer — Thu, 10 Sep 2020 11:55:12 GMT

Just put text() around it like: text(num(Index, '(bin)'))

- Marcus

dana — Thu, 10 Sep 2020 12:23:27 GMT

Cool!!

Thanks!