topic Re: Help in QlikView

Help

Thu, 04 Jun 2015 06:10:03 GMT

Hi,

Tell Me Solution.My Input Table is Below

f1 f2

A, 1

B, 2

C, 3

D, 4

E, 5

F, 6

G, 7

H, 8

I Want To This OutPut.It Should Be Dynamically code. Please Help Me.

f1 f2

AB, 3

BC, 5

CD, 7

DE, 9

EF, 11

FG, 13

GH, 15

Re: Help

pokassov — Thu, 04 Jun 2015 06:27:14 GMT

Hello!

t1:

LOAD * Inline [

f1, f2

A, 1

B, 2

C, 3

D, 4

E, 5

F, 6

G, 7

H, 8

];

left Join (t1)

LOAD *, RecNo() as ID

Resident t1;

Left Join (t1)

LOAD ID-1 as ID, f1 as f1new, f2 as f2new

Resident t1;

t2:

LOAD

f1&f1new as f1,

f2+f2new as f2

Resident t1

Where not IsNull(f2new);

DROP Table t1;

Re: Help

MayilVahanan — Thu, 04 Jun 2015 06:48:54 GMT

Try like this

LOAD * where f2 <> Null();

LOAD Previous(f1)&f1 as f1, f2+Previous(f2) as f2;

LOAD * Inline

[

f1,f2

A, 1

B, 2

C, 3

D, 4

E, 5

F, 6

G, 7

H, 8

];

Re: Help

Thu, 04 Jun 2015 07:00:35 GMT

hi,

See the attached sample..

Re: Help

Thu, 04 Jun 2015 07:02:48 GMT

Refer the link below.

Logic Help

Re: Help

djsampat — Thu, 04 Jun 2015 07:20:51 GMT

Hi Lalit,

Using the above logic by @Сергей Покасов, I have created a qvw so you can see it at work if you did not understand the coding.

view attached.

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

If you are viewing this topic and found it informative, please like my comment.

Regards

Dhruv

Re: Help

MarcoWedel — Thu, 04 Jun 2015 08:18:42 GMT

Please also answer the questions in your thread

Help

Thanks

Regards

Marco