topic Re: Extract values in special fields in App Development

Extract values in special fields

mostal75 — Sat, 16 Nov 2024 06:44:24 GMT

Hello,

I need your help to manage special case found.

In database my field store numbers like 1, 2, 33, 1027.....

In fact, each 2^x represent specific value.

For example:

2^0=1 --> blue car

2^1=2 --> red car

2^2=4 --> orange car

.....

For a customer, this field stores any cars they have. If they have a blue car, value is simple: 1. If a customer have 2 cars, the value is the sum of the two values (example: 6 for a red and orange car). I have lots of combination so it seems impossible to create a pick/match function.

Do you have any idea to extract each single result (cars) in this example please ?

Regards

Regis

Re: Extract values in special fields

dplr-rn — Mon, 28 Jan 2019 14:49:29 GMT

Not 100 % clear. i am assuming you get x (in the 2^x) from your data.
Did you try creating a map and applymap for blue/orange thing

Re: Extract values in special fields

sunny_talwar — Mon, 28 Jan 2019 14:54:18 GMT

So, if a customer has a value of 4... does it mean that he has 3 cars (2 blue and 1 red) or 2 cars (2 red) or 1 car (1 orange)? if the value is summed, how will you differentiate?

Re: Extract values in special fields

mostal75 — Mon, 28 Jan 2019 15:36:01 GMT

that's not possible with map/applymap because when 2 values summed in the field the maping can't match each individual values

Example:

red car =1

blue car=2

myfield value is 3 and i need to retrieve the two values

Re: Extract values in special fields

mostal75 — Mon, 28 Jan 2019 15:40:12 GMT

Sunny_talwar, thanks for your help
Hopefully we only have an value maximum by type
If we have 3 cars there's only 1 of each color
For this example: 3 cars (red=2^0=1, orange=2^1=2, green=2^2=4) my fiedl value will be 4+2+1=7

Re: Extract values in special fields

sunny_talwar — Mon, 28 Jan 2019 15:42:22 GMT

Are you saying that you would know in advance how many cars each one of them have?

Re: Extract values in special fields

mostal75 — Mon, 28 Jan 2019 15:44:58 GMT

In fact, with the field value, I need to extract which car the person have
value 7 -> 3 cars: 1 red, 1 orange, 1 green
value 1 -> 1 car: 1 red

Re: Extract values in special fields

sunny_talwar — Mon, 28 Jan 2019 15:51:26 GMT

But value 7 can also mean 4 cars = 1 orange and 3 blue cars, isn't it?

Re: Extract values in special fields

sunny_talwar — Mon, 28 Jan 2019 15:52:29 GMT

I guess if I see a value, how do I know what makes it up... is it 4+2+1 or is it 4+1+1+1 or 2+2+2+1 or 2+1+1+1+1+1?

Re: Extract values in special fields

mostal75 — Mon, 28 Jan 2019 15:53:17 GMT

Hopefully not 🙂
Only 1 color by car in a field line

Re: Extract values in special fields

sunny_talwar — Mon, 28 Jan 2019 15:54:58 GMT

@mostal75 wrote:
Hopefully not 🙂
Only 1 color by car in a field line

Hopefully not? What are you saying? I am not sure I follow your question and your data well enough... can you share an image of your data to help us understand what you have?

Re: Extract values in special fields

dwforest — Mon, 28 Jan 2019 17:15:29 GMT

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/Operators/BitOperators.htm
Think this may be what you're looking for.
in your example: 7 bitand 2 = 1
and 6 bitand 1 = 0
This would allow you to test your total value to see if the specific color bit it set.

Re: Extract values in special fields

mostal75 — Mon, 28 Jan 2019 19:33:11 GMT

thanks a lot
I have a look and keep you in touch

Regards

Re: Extract values in special fields

mostal75 — Tue, 29 Jan 2019 12:35:05 GMT

Sounds grenat
Thanks a lot