Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dena_reavis
Employee
Employee

Qlikview Bitand Function, how to use with large numbers?

I use this concat alternative for dynamic tables frequently. It makes users very very happy... so big thanks to DFoster9 for that post, which is 5 years old I know, but still - it is awesome. For the first time though, I am running into a problem when referring to a large number of the Dimension Value, highlighted below. 

2019-08-06_16-14-19.png

I am using the same method of assigning the value by using 2 ^ n starting with 0. That works fine until I reach 62... 2^ 61 is okay, 2^62 isn't. I have read a lot about the bitand function, including Arturo Muñoz's very helpful post here, I suspect my problem is not a Qlik thing, but maybe I could change how I refer to the number. 

2019-08-06_16-28-02.png

the vGetAdhocFields variable is just the GetSelected Count. 

2019-08-06_16-30-40.png

I know that this sounds like a lot of dimensions but these really are valid in the business, and just a fraction of the possible fields. I would appreciate any suggestions anyone may have. 

Thank you

Labels (1)
1 Reply
dena_reavis
Employee
Employee
Author

SunnyTalwar, can you help me with this?