topic Re: Replicating the attached excel formula in QV. in QlikView

Replicating the attached excel formula in QV.

Tue, 12 May 2015 05:26:25 GMT

Hi Everyone,

Can anyone help me in replicating the attached excel formula in Column G in QV?

Re: Replicating the attached excel formula in QV.

anbu1984 — Tue, 12 May 2015 05:31:06 GMT

Can you post sample excel file

Re: Replicating the attached excel formula in QV.

Gysbert_Wassenaar — Tue, 12 May 2015 05:36:19 GMT

Try =RowNo()

Re: Replicating the attached excel formula in QV.

danieloberbilli — Tue, 12 May 2015 05:47:38 GMT

Try something like

Re: Replicating the attached excel formula in QV.

kavita25 — Tue, 12 May 2015 05:49:08 GMT

Please post a sample excel file...and is this formula is fixed for G9 only or whole column G ???

Regards,

Kavita

Re: Replicating the attached excel formula in QV.

jonathandienst — Tue, 12 May 2015 05:52:42 GMT

In script, use Peek and/or Previous to fetch the row above, something like this:

If([Sold-to-Party code] = '', '',

If([Sold-to-Party code] = Previous([Sold-to-Party code]), Peek(ATMPG) + 1, 1))

As ATMPG

Re: Replicating the attached excel formula in QV.

Gysbert_Wassenaar — Tue, 12 May 2015 05:55:47 GMT

That's assuming the fields are part of the same table. If they are then if(len(trim([Sold-to-Party code])),autonumber(ATMPG,[Sold-to-Party code]),'') would do the trick as well I reckon.