topic Re: peek function in QlikView

peek function

Anonymous — Fri, 20 Jan 2017 13:11:30 GMT

no	sales	output
1	10	10
2	20	30
3	40	70
4	50	120

From the table i want the first sales value in output column, after i want to add the first value in output column and second value in sales column. similarly all the values add. which function can be use?

Re: peek function

sunny_talwar — Fri, 20 Jan 2017 13:14:37 GMT

Something like this

RangeSum(Peek('output'), sales) as output

Re: peek function

Anonymous — Fri, 20 Jan 2017 13:21:48 GMT

sunny,

In my table i am having only no and sales, and the output field will be create using expression only.

in that field come at like above result

Re: peek function

sunny_talwar — Fri, 20 Jan 2017 13:23:32 GMT

Are you doing this on the front end? May be this...

RangeSum(Above(Sum(sales), 0, RowNo()))

Re: peek function

Anonymous — Fri, 20 Jan 2017 13:24:08 GMT

Hi Nithyakala,

To do cumulative task, in expression you have option for accumulation.

In given case above, go to Chart Properties -> Expression Tab, select "Full Accumulation".

Re: peek function

Anonymous — Fri, 20 Jan 2017 13:26:50 GMT

nope, am using script. am used this following expression,

load *, no|sales

1|10,

2|20,

3|40,

4|50;

Re: peek function

Anonymous — Fri, 20 Jan 2017 13:26:56 GMT

Please find attached the file for example

Re: peek function

surendraj — Fri, 20 Jan 2017 13:30:11 GMT

Hi,

Refer the above link.it may help you with clear Explanation.

Calculating rolling n-period totals, averages or other aggregations

--Surendra

Re: peek function

sunny_talwar — Fri, 20 Jan 2017 13:31:28 GMT

Here you go...

Table:

LOAD * INLINE [

no, sales

1, 10

2, 20

3, 40

4, 50

];

FinalTable:

LOAD *,

RangeSum(Peek('output'), sales) as output

Resident Table

Order By no;

DROP Table Table;

Re: peek function

Anonymous — Fri, 20 Jan 2017 13:35:31 GMT

ya its coming. thank you