topic Issue in QlikView

Issue

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

Hai all good eve to all,

i have one requirement,Can any any one tell me how to do this in backend .

Please find below attchment for reference.I want new field like screenshot

Re: Issue

Anonymous — Fri, 04 Mar 2016 11:07:52 GMT

do like this?

Load * inline

[Project, Subproject, NewField

A,1234, qwe

A, 2345, fgh

and so on....

];

Re: Issue

sunny_talwar — Fri, 04 Mar 2016 11:11:01 GMT

May be try this:

Table:

LOAD Project,

Sub Project

FROM Source;

FinalTable:

LOAD *,

If(Project = Peek('Project'), RangeSum(Peek('NewField'), 1), 1) as NewField

Resident Table

Order By Project;

DROP Table Table;

UPDATE: Missed a single quote after Project field within Peek

Re: Issue

avinashelite — Fri, 04 Mar 2016 11:11:41 GMT

what's you requirement ?? you want to create a table in the script ??

could you please explain your requirement

Re: Issue

sunny_talwar — Fri, 04 Mar 2016 11:15:33 GMT

I am assuming that it is to create the NewField in the image , But I may very well be wrong here

Re: Issue

avinashelite — Fri, 04 Mar 2016 11:17:41 GMT

No , Bro ..I think that might be the requirement ... lets wait for the reply

Re: Issue

subbareddykm — Fri, 04 Mar 2016 11:19:30 GMT

Sunny,

what i want is my output field is New Field.How to acheive that ?

Re: Issue

avinashelite — Fri, 04 Mar 2016 11:26:13 GMT

did you check the previous post by Sunny ??

Re: Issue

sunny_talwar — Fri, 04 Mar 2016 11:26:42 GMT

Try this:

DATA:

LOAD Project,

[Sub Project]

FROM

[ACCUMILATION.xlsx]

(ooxml, embedded labels, table is Sheet1);

FinalTable:

LOAD *,

If(Project = Peek('Project'), RangeSum(Peek('NewField'), 1), 1) as NewField

Resident DATA

Order By Project;

DROP Table DATA;

Re: Issue

vikasmahajan — Fri, 04 Mar 2016 11:32:31 GMT

HTH

Vikas

Re: Issue

tresB — Fri, 04 Mar 2016 11:36:23 GMT

A simpler way is:

Autonumber(SubProject, Project) as Sequence

Or,

Autonumber(RecNo(), Project) as Sequence