topic Re: Fields Help in Load Script in QlikView

Fields Help in Load Script

Anonymous — Thu, 09 Jul 2015 18:52:05 GMT

Hi All,

I'm trying to combine 2 fields in the load script into 1 field. Both of these fields has values.

Example: Field_A and Field_B has a value of 100 and i would like to create a field called Field_X.

something like this.

Field_A & Field_B as Field_X

Any input will be greatly appreciated!.

Frank

Re: Fields Help in Load Script

maxgro — Thu, 09 Jul 2015 18:55:07 GMT

load

Field_A,

Field_B,

Field_A & Field_B as Field_X,

....

from

.....

Re: Fields Help in Load Script

MK_QSL — Thu, 09 Jul 2015 18:55:17 GMT

Load

Field_A,

Field_B,

Field_A & Field_B as Field_C

From ....

Re: Fields Help in Load Script

sunny_talwar — Thu, 09 Jul 2015 18:55:35 GMT

By combining you mean placing them next to each other? Like 100100 in your example?

If that's true your script should work Field_A & Field_B as Field_X. Is it not working?

Re: Fields Help in Load Script

Anonymous — Thu, 09 Jul 2015 19:05:22 GMT

Sunindia,

good catch.

No, i need Field_X as the sum of Field_A & Field_B.

A=100

B=100

X=200

Re: Fields Help in Load Script

sunny_talwar — Thu, 09 Jul 2015 19:07:24 GMT

then it should be Field_A + Field_B as Field_X

Re: Fields Help in Load Script

sunny_talwar — Thu, 09 Jul 2015 19:09:27 GMT

and if there is a chance that one of them might be null and you would still want them to be Summed together (like A = 100, B = Null() -> X = 100) then try this:

RangeSum(Field_A, Field_B) as Field_X or

Alt(Field_A, 0) + Alt(Field_B, 0) as Field_X

HTH

Best,

Sunny

Re: Fields Help in Load Script

MK_QSL — Thu, 09 Jul 2015 19:09:38 GMT

RangeSum(Field_A, Field_B) as Field_X

Re: Fields Help in Load Script

Anonymous — Thu, 09 Jul 2015 20:23:33 GMT

Thank you All for the input!.

Sunindia and Manish - both of your answer works

RangeSum(Field_A, Field_B) as Field_X

Re: Fields Help in Load Script

sunny_talwar — Thu, 09 Jul 2015 20:25:16 GMT

No problem

I am glad that we were able to help.

Best,

Sunny