topic Re: Logic help in QlikView

Logic help

abhaysingh — Wed, 25 Nov 2020 16:16:04 GMT

Hey Guys,

Pls help me in this logic pls..

I have three field

Field1	Field2	Field3	Field4
1			1
2			20
3			31
	4		41
	5		53
	6		6
		7	7
		8	84
		9	96
		10	10

I want output as

Final output

How i can achieve it? without concatenating four three times

Re: Logic help

Gysbert_Wassenaar — Fri, 15 Apr 2016 08:21:04 GMT

LOAD

alt(Field1,Field2,Field3) as Result

FROM

...somewhere

Re: Logic help

Kushal_Chawda — Fri, 15 Apr 2016 08:45:36 GMT

another way

Data:

LOAD Field1 as Field

FROM Table

Where len(trim(Field1))>0;

concatenate(Data)

LOAD Field2 as Field

FROM Table

Where len(trim(Field2))>0;

concatenate(Data)

LOAD Field3 as Field

FROM Table

Where len(trim(Field3))>0;

Sorry I didn't see the last line of your quesion

Re: Logic help

abhaysingh — Fri, 15 Apr 2016 08:51:46 GMT

If i have text value in my field1,2,3,

will this work?

Re: Logic help

Kushal_Chawda — Fri, 15 Apr 2016 08:53:50 GMT

also try

LOAD trim(Field1&Field2&Field3) as Field

FROM Table

Re: Logic help

abhaysingh — Fri, 15 Apr 2016 08:57:41 GMT

hi gysbert,

could you pls provide the sample file, its not working at my end

thanks for your support

Re: Logic help

Gysbert_Wassenaar — Fri, 15 Apr 2016 08:58:48 GMT

No. The alt function only works with numbers. If you have text you can try what kush141087 posted above

Re: Logic help

abhaysingh — Fri, 15 Apr 2016 08:58:54 GMT

Hi Kushal,

this will only concat the field , will not give desired output i want.

thanks for revert

Re: Logic help

Gysbert_Wassenaar — Fri, 15 Apr 2016 09:00:52 GMT

Then perhaps:

If(Len(Trim(Field1)),Field1,If(Len(Trim(Field2)),Field2,Field3)) as Result

Re: Logic help

Kushal_Chawda — Fri, 15 Apr 2016 09:02:17 GMT

Can you show me what you are getting as output using that?