topic Re: Simple in excel, don't know how to do it in QlikView Load Script in QlikView

Simple in excel, don't know how to do it in QlikView Load Script

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

Hi!.How can I make this to work in load script?

I have this in one table

ref

I need to load new table "calc" this way

calc

Start value, Same value as in Ref = 1

Current ref value/previos calc value 6/1=6

Current ref value/previos calc value 2/6=0.33

Current ref value/previos calc value 8/0.33=24.24

Current ref value/previos calc value 7/24.24=0.28

So new calc table must be like this

calc

0.33

24.24

0.28

Any help will be preciated.

Thanks in advsance

Re: Simple in excel, don't know how to do it in QlikView Load Script

Anonymous — Fri, 03 Nov 2017 18:56:53 GMT

Ref/Previous(Ref) as Calc

or Ref/Peek(Ref) as Calc

Re: Simple in excel, don't know how to do it in QlikView Load Script

Anonymous — Fri, 03 Nov 2017 19:06:19 GMT

Thanks Wallo!

Previous and Peek does not work, I get "field not found", and O think this is because I'm creating "calc" value

Here's the code I wrote

tmpTableCalcWithPrevious:

LOAD *,

If(ref = 1, 1, ref/Previous(calc)) as calc

Resident tmpTableRef;

tmpTableWithPeek:

LOAD *,

If(ref = 1, 1, ref/Peek(calc)) as calc

Resident tmpTableRef;

Any clue?

Re: Simple in excel, don't know how to do it in QlikView Load Script

Anonymous — Fri, 03 Nov 2017 19:14:41 GMT

This works for me.

Re: Simple in excel, don't know how to do it in QlikView Load Script

Anonymous — Fri, 03 Nov 2017 19:28:24 GMT

Thanks again Wallo!! Your code works, but the calculation I need is different.

You're doing ref/Previous(ref) as calc

I need (but don't know hou to do it) ref/Previous(calc) as calc

Re: Simple in excel, don't know how to do it in QlikView Load Script

Anonymous — Fri, 03 Nov 2017 19:32:39 GMT

I gotcha. Here take a look at this.

Re: Simple in excel, don't know how to do it in QlikView Load Script

Anonymous — Fri, 03 Nov 2017 19:40:37 GMT

Awesome. Thanks a lot!!!