topic Re: Previous data in QlikView

Previous data

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

Hi all,

I have a data like below

Name,sales

aa,100

bb,200

cc,300

dd,400

here I want output like

Newcolumn

300 [100+200]

500

700

how can I achieve this?

Thanks

Re: Previous data

sunny_talwar — Fri, 27 Oct 2017 16:40:01 GMT

You want this in a chart or script?

Re: Previous data

el_aprendiz111 — Fri, 27 Oct 2017 17:49:41 GMT

Hi,

1 option

LOAD *, PEEK(sales)+sales AS Newcolumn;
LOAD * Inline
[
Name,sales
aa,100
bb,200
cc,300
dd,400
];

Re: Previous data

kicchu465 — Fri, 27 Oct 2017 17:56:46 GMT

Hi Fer,

Thanks for the reply.

Its working fine now.

much appreciated for the video provided.

Thanks,

Kb

Re: Previous data

its_anandrjs — Fri, 27 Oct 2017 18:03:02 GMT

You can do the same with RangeSum()

LOAD *,RangeSum( Previous(Sales)+Sales ) as NewCol;

LOAD * Inline

[

Name,Sales

aa,100

bb,200

cc,300

dd,400

];